sql sub queries

Feb 7 2015 11:50 AM

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)

Query Performance Low while compare two lacks Loan ID

Grant Administrative Rights on SQL server 2012