SQL 13) 从titles表获取按照title进行分组
从titles表获取按照title进行分组
http://www.nowcoder.com/questionTerminal/72ca694734294dc78f513e147da7821e
方法)分组再用HAVING筛选
SELECT title, COUNT(emp_no) AS t FROM titles GROUP BY title HAVING t >= 2;
从titles表获取按照title进行分组
http://www.nowcoder.com/questionTerminal/72ca694734294dc78f513e147da7821e
SELECT title, COUNT(emp_no) AS t FROM titles GROUP BY title HAVING t >= 2;
相关推荐