select s.emp_no, max(s.salary), e.last_name, e.first_name FROM salaries s JOIN employees e ON s.emp_no = e.emp_no where s.salary <(select max(salary) FROM salaries and to_date = '9999-01-01') and s.to_date = '9999-01-01',请问这样写为什么不行?
1

相关推荐

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