厉害的~看到好多人都是用这两种方法来做,我的方法和方法二类似,但是稍微简化了一点,感兴趣的可以参考一下: SELECT c.emp_no,c.salary,d.last_name,d.first_name FROM (SELECT a.emp_no,MIN(a.salary) AS 'salary' FROM salaries a JOIN salaries b ON a.salary <= b.salary WHERE a.to_date = '9999-01-01' AND b.to_date = '9999-01-01' GROUP BY a.emp_no HAVING COUNT(b.emp_no) = 2)c LEFT OUTER JOIN employees d ON c.emp_no = d.emp_no;
1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务