SELECT sa.emp_no,sa.t from (SELECT emp_no,count(*) as t from salaries GROUP by emp_no ) AS sa WHERE sa.t>15 使用子查询的一种方法
SELECT sa.emp_no,sa.t from (SELECT emp_no,count(*) as t from salaries GROUP by emp_no ) AS sa WHERE sa.t>15 使用子查询的一种方法
牛客博客，记录你的成长
京公网安备 11010502036488号