99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

熱線電話：13121318867

登錄
2018-11-01 閱讀量: 841
MySQL分組查詢

----group by

查詢每個(gè)供應(yīng)商商品數(shù)量

select s_id，count(*) as 商品數(shù)量（as可省略）

from fruits

group by s_id

order by count (*) desc;

排序總是在最后

查詢供應(yīng)商品數(shù)量少于兩個(gè)的供應(yīng)商id

對(duì)于分組結(jié)果進(jìn)行篩選使用having子句

select s_id，count(*) as 商品數(shù)量（as可省略）

from fruits

group by s_id

having count(*)<2

order by count (*) desc;

0.0000
3
關(guān)注作者
收藏
評(píng)論(0)

發(fā)表評(píng)論

暫無(wú)數(shù)據(jù)
推薦帖子