about sql query

[abes_nitya]

plz help me.... I want to find" top 5 sal from emp" how can we find???thanks.

[skym]

In mysql the query would be:SELECT sal FROM emp ORDER BY sal DESC LIMIT 5

[bhavik_solanki]

plz help me.... I want to find" top 5 sal from emp" how can we find???thanks.

In SQL server u can try this querySelect Distinct Top 2 salary from EmpSalary Order by salary Desc

[Raj Ali]

In SQL server u can try this querySelect Distinct Top 2 salary from EmpSalary Order by salary Desc

You use the querySelect top 5 salary from <table name>

[aspnetguy]

You use the querySelect top 5 salary from <table name>

No that will give you the first 5 records, if you are looking for the 5 highest salaries it would beMYSQL

SELECT * FROM emp ORDER BY sal DESC LIMIT 5

SQL Server/Access

SELECT TOP 5 * FROM emp ORDER BY sal DESC