SQL語(yǔ)句select?
看提示和單行行數(shù),你用的oracle數(shù)據(jù)庫(kù)把,對(duì)于oracle聚合函數(shù),以你這個(gè)SQL為例子,應(yīng)該在group by后加上sex,work_location, trunc(last_login)
也就是select count(*),sex,work_location,trunc(last_login) from user_info group by trunc(last_login),sex,work_location,