Tagged Questions
2
votes
2answers
100 views
Why does adding LIMIT to my query make it crawl?
Simple query:
select sum(score) total,name,gender,dob,country
from users join scores on users.id = scores.user_id
where date between '2012-01-01' and '2012-01-31 23:59:59'
group by scores.user_id ...
0
votes
2answers
196 views
limit and then group by in MySQL
I have a mysql table having following structure :
payment_id(int auto_increment),
emp_id(int),
chargeTime(datetime),
payment(double)
I need to have three latest (with respect to chargeTime) ...
