Interested to Buy Any Domain ? << Click Here >> for more details...
how to select second mauximum value in a given table under salary column
- 6 Answers
- 9322 Views
- Sapient, I also Faced
- E-Mail Answers
Answer Posted / utkal
Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).
Here n=2,
Similarily we can find the 5th highest salary etc...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is not equal to in oracle?
What is an anonymous block?
How can we find out the duplicate values in an oracle table?
What is pragma autonomous transaction in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the best way to do multi-row insert in oracle?
What is translate in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain the importance of .pll extension in oracle?
What do you mean by merge in oracle and how can we merge two tables?
How to drop an index in oracle?
Is oracle the best database?
