Quote:
Originally Posted by Mahesh RG
Hello can any buddy tel me can i write a query to get the top 3rd, 4th value from the table 'emp'?
|
SQL Qureies for retriew 3rd max salary:
Select max(salary) from emp where salary not in (select top 2 salary from emp order by salary desc)
Thanks & Regards
Alagu....