1.where用在group by 分组前的条件过滤
2.having用在group by 分组后的条件过滤
users
user_id | user_name | age |
1 | 红弦 | 18 |
2 | 红弦1 | 18 |
order_id | user_id | item_id | cost | time |
1 | 1 | 5 | 50 | 2016-07-07 |
2 | 1 | 5 | 100 | 2016-07-07 |
select users.user_id,users.user_name,users.age,sum(orders.cost) as allcost
from users join orders
on users.user_id = orders.user_id
group by orders.user_id
having allcost>100
order by allcost desc
limit 3;
from users join orders
on users.user_id = orders.user_id
group by orders.user_id
having allcost>100
order by allcost desc
limit 3;