å
è¿è¡åç»å¤çã
Group By å Having, Where ,Order byè¿äºå
³é®åæ¯æç
§å¦ä¸é¡ºåºè¿è¡æ§è¡çï¼Where, Group By, Having, Order byã
é¦å
whereå°æåå§è®°å½ä¸ä¸æ»¡è¶³æ¡ä»¶çè®°å½å é¤(æ以åºè¯¥å¨whereè¯å¥ä¸å°½éçå°ä¸ç¬¦åæ¡ä»¶çè®°å½çéæï¼è¿æ ·å¯ä»¥åå°åç»ç次æ°)
ç¶åéè¿Group Byå
³é®ååé¢æå®çåç»æ¡ä»¶å°çéå¾å°çè§å¾è¿è¡åç»
æ¥çç³»ç»æ ¹æ®Havingå
³é®ååé¢æå®ççéæ¡ä»¶ï¼å°åç»è§å¾åä¸æ»¡è¶³æ¡ä»¶çè®°å½çéæ
æåæç
§Order Byè¯å¥å¯¹è§å¾è¿è¡æåºï¼è¿æ ·æç»çç»æ就产çäºã
å¨è¿å个å
³é®åä¸ï¼åªæå¨Order Byè¯å¥ä¸æå¯ä»¥ä½¿ç¨æç»è§å¾çååï¼å¦ï¼
SELECT FruitName, ProductPlace, Price, ID AS IDE, Discount
FROM T_TEST_FRUITINFO
WHERE (ProductPlace = N'china')
ORDER BY IDE
è¿éåªæå¨ORDER BYè¯å¥ä¸æå¯ä»¥ä½¿ç¨IDEï¼å
¶ä»æ¡ä»¶è¯å¥ä¸å¦æéè¦å¼ç¨ååååªè½ä½¿ç¨IDï¼èä¸è½ä½¿ç¨IDEã
温馨提示:答案为网友推荐,仅供参考