Codings

Hello Sir,

Can i plz have query of "Find the 6th highest salary from the table" .....plz send me d query

Newbie Poster

17 posts since May 2008

Reputation Points: 10

Solved Threads: 0

Try this code below:

select top 1 * 
  from (select top 6 *
	  from #tmpSalary
	  order by Salary) X
  order by Salary desc

Light Poster

48 posts since Feb 2008

Reputation Points: 10

Solved Threads: 13

This article has been dead for over three months

You