sql query

[joindotnet]

I want to retrieve top 2 of maximum salary records.What wud be the qeury???:confused::confused::confused::confused::confused::confused::confused:

[Meysam Mahfouzi]

If you've got only one table containing all salaries, your answer is as simple as this:

SELECT TOP(2) Salary
FROM TABLE
ORDER BY Salary DESC

_

[joindotnet]

Can u plz tell if I want to get minimum of top 2.

[Giorgi Dalakishvili]

Order the records in ascending order and select top two :)

Giorgi Dalakishvili #region signature My Articles / My Latest Article[^] / My blog[^] #endregion

[vaseeem]

select top 2 salary from tbl_salary order by salary desc select top 2 salary from tbl_salary order by salary asc

Errors are like Mini Skirts, shorter they get, more revealing they become.

[Lost User]

Now I got a question for you; Imagine you want to retrieve the top 3 salary records. How would you go about and do that? :-D

[joindotnet]

you din understand my question and now making fun of me.'minimum of top 2' means the lesser of the top 2 that is the second largest salary.Now if you are too smart tell this eddyvluggen.

[Lost User]

joindotnet wrote:

making fun of me

I was, wasn't I?

joindotnet wrote:

What wud be the qeury???

You just wanted someone to write a query for you, and someone did. Have you actually tried writing the query? If so, why didn't you post the piece that you already wrote?

[joindotnet]

I can write the queries by myself. I just wanted to know whether there is a simplification for it select min(salary) from (select top 2 salary from order by salary desc) By the way this place is for professionals not for people like u who r here to have fun.

[leckey 0]

I didn't know professionals could not have fun. If you ask an oversimple question or break the forum guidelines, you will get flamed.

Blog link to be reinstated at a later date.