Oct15

想把COUNT放到where子句中?

嘿嘿,这就说明你的数据库课没有学好……   错误做法:select * from user_num where count(user)>=2 group by user;   正确做法:select * from user_num group by user HAVING count(user)>=2 ; 用having子句吧!

trackback Tags: 评论 (3)