MySQL的5种子句查询_MySQL

来源：动视网责编：小采时间：2020-11-09 19:25:50

MySQL的5种子句查询_MySQL

MySQL的5种子句查询_MySQL: 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

推荐度：

点击下载本文 文档为doc格式

导读MySQL的5种子句查询_MySQL: 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

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

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

MySQL的5种子句查询_MySQL

推荐度：

点击下载本文 文档为doc格式

标签：查询 mysql 中查询

热门焦点

MySQL的5种子句查询_MySQL

MySQL的5种子句查询_MySQL

MySQL的5种子句查询

1.where

2.group by 分组查询

3.having

4.order by

5.limit

MySQL的5种子句查询_MySQL

最新推荐

猜你喜欢

热门推荐