Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37880 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 the use of double ampersand (&&) in sql queries? Give an example
How do we accept inputs from user during runtime?
What is the difference between row level and statement level trigger?
how to get help information from the server? : Sql dba
what is collation? : Sql dba
What is rtm in testing?
What is schema in sql example?
How to install oracle sql developer?
Can you have more than one trigger on a table?
what is csv? : Sql dba
Can we use update in sql function?
what is an index? : Sql dba
Is truncate ddl or dml?
How can I delete duplicate rows?
What is the difference between rollback and rollback to statements?
