Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37951 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 out parameter used for eventhough return statement can also be used in pl/sql?
What does select * from mean in sql?
How to rename a table?
Differentiate between % rowtype and type record.
How to process query result in pl/sql?
What is string data type in sql?
explain advantages of myisam over innodb? : Sql dba
How do I edit a stored procedure?
Whis is not false in primary key?
how to calculate expressions with sql statements? : Sql dba
How can get second highest salary in sql?
How do you declare a user-defined exception?
What are different types of statements supported by sql?
What is sql stand for?
What is delimiter sql?
