MySQL的5种子句查询_MySQL
程序员文章站
2023-12-25 17:09:57
...
MySQL的5种子句查询
1.where
where shop_price>300 and shop_price500
- between
where shop_price between 300 and 500
where shop_price >= 300 and shop_price
- in
where cat_id in(4,5,6)cat_id=4 cat_id=5 cat_id=6
2.group by 分组查询
group by 需要配合一下5个聚合函数使用:
- max
- min
- avg
- sum
- count
select cat_id.max(shop_price) from goods group by cat_id;
3.having
having必须作用于where之后
select cat_id,sum(shop_price*goods_number) as huokuan from goods group by cat_id having huokuan>20000;
4.order by
- asc---顺序,默认值
- desc---倒序
5.limit
limit[偏移量],条数
偏移量默认为0