1
Answer

sql sub queries



I have employee table with empname, dept,salary
----------------------------------------------------------
in this i want to get highest salary paid employee in each dept




output as like


empname  dept   salary

Answers (1)