How shoud I retrieve 3 max salaried persons from my Table Employee?

Question

anyone give the sql?

I want a query which run in SQL Server 2000

I don't want the topmost 3 rows.I just want 3 persons who gets the highest salary.
for eg.2000,1000,3000,5000,750 r the salary.
I want to retrievt 2000,3000,5000 from the table.

Answer 1

SELECT TOP 3 T_Employee.*
FROM T_Employee
ORDER BY T_Employee.Salary DESC;

Add TOP x following SELECT to return the first x records of your query.
ORDER BY decending (DESC) on the particular field in this case Salary. Above query will then return all fields in the records of the top 3 highest salaried employees.

Answer 2

The previous query was correct. If you sort your records by salary in decending order -- e.g., from highest to lowest -- then the top 3 records are the three highest salaries.

SELECT TOP 3 namecolumn FROM salarytable ORDER BY salarycolumn DESC

Answer 3

depends on your database but here goes:

select * from employee order by salary desc limit 3;