牛客网刷题之SQL-14.牛客网刷题之SQL-13.从titles表获取按照title进行分组

    科技2022-07-12  125

    牛客网刷题之SQL-13.从titles表获取按照title进行分组

    目录

    1. 题目

    2. 解题


    题目链接

    1. 题目

    2. 解题

    SELECT title, COUNT(DISTINCT emp_no) AS t FROM titles GROUP BY title HAVING t >= 2;

     

    Processed: 0.009, SQL: 8