Article:  |
SQL Data Types | |
| Subject: | how do we find nth highest in SQL | |
| Date: | 2006-02-01 02:50:14 | |
| From: | neerenderlamp | |
|
Response to: how do we find nth highest in SQL
|
||
| i 2 don't know really iam searching for that | ||
Showing messages 1 through 1 of 1.
-
how do we find nth highest in SQL
2006-04-17 07:57:07 sainiks [View]
Select * from Employee where salary =
(Select max(Salary) from Employee where salary < (Select max(Salary) from Employee where
Salary<(Select max(Salary) from Employee where
Salary <…………………………………………… N
The above query can be continued n timesif you require nth highest salary
2.
Select * From Employee E1 Where
(N-1) = (Select Count(Distinct(E2.Salary)) From Employee E2 Where
E2.Salary > E1.Salary)
here you require N th highest salary
Those were two choices , i think 2nd one will take a bit time.