how to check the 3rd max salary from an employee table?
- 23 Answers
- 30081 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
What is a recursive join sql?
What is not in sql?
What is difference between pls_integer and integer?
what is auto increment? : Sql dba
How do you truncate?
Write a sql select query that only returns each name only once from a table?
Advantages and disadvantages of stored procedure?
How to use distinct and count in sql query? Explain
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How to avoid using cursors?
Does pl sql work in mysql?
Why do we use procedures?
What is the location of pre_defined_functions.
Is it possible to read/write files to-and-from PL/SQL?
Is a secondary key the same as a foreign key?
