Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38659 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
Can we commit inside a trigger?
How do I audit the sql sent to the server?
What are the disadvantages of file system?
is it possible to pass an object or table to a procedure as an argument?
What is thread join () in threading?
How do you define a foreign key?
What are sql procedures?
What is a clob in sql?
Explian rowid, rownum? What are the psoducolumns we have?
can a stored procedure call itself or recursive stored procedure? : Sql dba
Can there be 2 primary keys in a table?
How to find 3rd highest salary of an employee from the employee table in sql?
What is lexical units in pl sql?
What is the sql*loader? : aql loader
What are procedures used for?
