sql面试题学习记录

SELECT shuming FROM test WHERE pingjia='好' GROUP BY shuming ORDER BY COUNT(shuming) DESC LIMIT 1; SELECT COUNT(DISTINCT(shuming)) FROM test;