How can I retrieve top 10 salaries using SQL query

[mohanq]

Hi,

How can i get top 10 salaries from employee table, where employee table has the following columns:-

empno int,
empname varchar(35),
age int,
salary double,
location varchar(50)

If any one knows the solution for my question, pls let me know.

Thanks in advance,
mohan.

 

[vincer]

select top 10 salary order by salary desc

or

select distinct top 10 salary order by salary desc