聚合函數不能作為條件出現在WHERE裏面,那我們怎麼做呢,用HAVING
SELECT 出版社, sum(單價*數量) FROM books GRUOP BY 出版社 HAVING sum(單價)>30;
除此以外我們很少用到having
查詢重複的有哪些
SELECT a1,count(a1) FROM aa GROUP BY a1 HAVING COUNT(a1)>1;
聚合函數不能作為條件出現在WHERE裏面,那我們怎麼做呢,用HAVING
SELECT 出版社, sum(單價*數量) FROM books GRUOP BY 出版社 HAVING sum(單價)>30;
除此以外我們很少用到having
查詢重複的有哪些
SELECT a1,count(a1) FROM aa GROUP BY a1 HAVING COUNT(a1)>1;