Find out the 3rd highest salary?
Answer Posted / dharmendra yadav
select min(salary) from (select name , salary , rownum from
Emp order by salary desc) where rownum <= 3 ;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why should I use postgresql?
What is Collation Sensitivity ? What are the various type ?
How many clustered indexes can be created on a table?
What are three advantages to using sql?
What is the best sql course?
What do you mean by table in sql?
how can you see all indexes defined for a table? : Sql dba
What is the unique index?
what is data control language? : Sql dba
What are sql*plus environment variables?
Why sql query is slow?
Is stored procedure faster than query?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How do you write a complex sql query?
What is a relationship and what are they?