Member Avatar for Jahira

Hello Sir,

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

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by huangzhi
Member Avatar for huangzhi

Try this code below:

select top 1 * 
  from (select top 6 *
	  from #tmpSalary
	  order by Salary) X
  order by Salary desc
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.