top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Select TOP 2 salary from employee table

+4 votes
309 views
Select TOP 2 salary from employee table
posted Nov 28, 2014 by Manikandan J

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Plz clear the case where you facing problem?

1 Answer

+2 votes
 
Best answer
select top 2 * from employee order by salary desc
answer Dec 1, 2014 by Shivaranjini
Similar Questions
+1 vote

How we can get nth max salary from Employee Table (EMP_ID, Salary)

Emp_id salary
1 1000
3 2000
4 16000
2 10000
7 19000
8 12000

e.g. for 3rd max salary, salary is 12000 so answer will be emp_id : 8

...