sql sub queries

Question

I have employee table with empname deptsalary ---------------------------------------------------------- in this i want to get highest salary paid employee in each dept output as like empname dept salary

Joginder Banger · Answer

try this query select top 1 * from employee group by dept order by salary desc