每个部门中每个岗位的最高薪资
每个部门中每个岗位的最高薪资
select dept.dname ,emp1.job ,emp1.sal
from db_hive.tb_dept dept join db_hive.tb_emp emp1
on dept.deptno=emp1.deptno
where ( select count(emp2.sal) as c_sal from db_hive.tb_emp emp2
where emp2.sal>emp1.sal and emp2.deptno=emp1.deptno and emp2.job =emp1.job)<1
order by emp1.deptno,emp1.sal desc
错误信息:
FAILED: ParseException line 4:6 cannot recognize input near 'select' 'count' '(' in expression specification