how to check the 3rd max salary from an employee table?
Answer Posted / arjun
select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are all the common sql function? : Sql dba
Does group by remove duplicates?
Can we rollback truncate?
what is dbms? : Sql dba
Can delete statement be rollbacked?
Is primary key clustered index?
How do I remove duplicates in two columns?
what is sql server agent? : Sql dba
what is schema? : Sql dba
What is the best sql course?
What is the current version of sql?
Can we use distinct and group by together?
how many tables will create when we create table, what are they? : Sql dba
What is the current version of postgresql?
what is bcp? When does it used? : Sql dba