how to check the 3rd max salary from an employee table?
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
how to escape special characters in sql statements? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Is primary key clustered index?
what are the advantages of sql ? : Sql dba
what is dbms? : Sql dba
how to start mysql server? : Sql dba
What is the current version of postgresql?
Can delete statement be rollbacked?
Does group by remove duplicates?
Do we need to rebuild index after truncate?
how many tables will create when we create table, what are they? : Sql dba
what are all the common sql function? : Sql dba
what is schema? : Sql dba
define sql insert statement ? : Sql dba
Can we rollback truncate?