首页 >数据库 >mysql教程 >MySQL的5种子句查询_MySQL

MySQL的5种子句查询_MySQL

WBOY
WBOY原创
2016-06-01 13:10:371033浏览

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


声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn