MySQL的5种子句查询_MySQL

MySQL的5种子句查询

1.where

where shop_price>300 and shop_price<500where shop_price<300 or shop_price>500

• between

where shop_price between 300 and 500

where shop_price >= 300 and shop_price <= 500

• 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