2018-11-28
閱讀量:
904
SELECT語(yǔ)句的語(yǔ)法
SELECT〈目標(biāo)列組〉
FROM〈數(shù)據(jù)源〉
[WHERE〈元組選擇條件〉]
[GROUP BY〈分列組〉[HAVING 〈組選擇條件〉]]
[ORDER BY〈排序列1〉〈排序要求1〉 [,…n]];
-- 對(duì)大氣質(zhì)量表進(jìn)行有選擇的查詢
select city_name, avg(pm25), avg(pm10)
from Monthly_Indicator
where pm25 > 50
group by city_name, month_key having city_name <> '北京’
order by avg(pm25) desc;






評(píng)論(0)


暫無(wú)數(shù)據(jù)
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
1條評(píng)論
0條評(píng)論
0條評(píng)論