how to check the 3rd max salary from an employee table?
- 23 Answers
- 33803 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
1)SELECT MAX(SAL) FROM EMP WHERE LEVEL=3 CONNECT BY PRIOR
SAL>SAL
2)SELECT E.SAL FROM
(SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC)R FROM EMP)
E WHERE E.R=3
9966112520
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Which software is used for pl sql programming?
How to write a query to show the details of a student from students table whose
Is natural join and inner join same?
Is full outer join same as cross join?
What is pl sql record in oracle?
What is the difference between jpql and sql?
how can we repair a mysql table? : Sql dba
what is recursive stored procedure? : Sql dba
Do we need commit after truncate?
Explain raise_application_error.
What is latest version of sql?
what is isam? : Sql dba
What is the difference between Union and Union all. Which is faster.
what are the differences between binary and varbinary? : Sql dba
how many ways to get the current time? : Sql dba
