Codings

Expand Post »

Hello Sir,

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

Similar Threads

How to run external .exe programs from java in Java
Help needed for a printing routine in Visual Basic 4 / 5 / 6
Fonts in Java
Saving a file in Java
Is c # slower than c/c++ in C++

Jahira

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

17 posts
since May 2008

Permalink

Oct 11th, 2008

Re: Codings

Try this code below:

MS SQL Syntax (Toggle Plain Text)
SELECT top 1 * 
  FROM (SELECT top 6 *
	  FROM #tmpSalary
	  ORDER BY Salary) X
  ORDER BY Salary DESC
select top 1 * 
  from (select top 6 *
	  from #tmpSalary
	  order by Salary) X
  order by Salary desc

huangzhi

Reputation Points: 10

Solved Threads: 13

Light Poster

Offline

48 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Query query!

Next Thread in MS SQL Forum Timeline: Split record into 2 records

DaniWeb Message

Cancel Changes

User Name
Password