Dear friends,
How to display the name of the employee whose is getting highest salary.
What is the sql server query?
Regards
Amulya
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Nov 15, 2011, 11:37 PM
Try this...
select employeename from employee where salary=(select max(salary) from employee)
Thanks
Prabhu RajaPosted Nov 19, 2011, 1:44 PM
http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/