Find out the 3rd highest salary?
Answer Posted / ratnakar
select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;
Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
What are different types of queries in sql?
Why do we use procedures in sql?
Explain exception handling in pl/sql?
Is a secondary key the same as a foreign key?
What is pl sql commands?
How to add, remove, modify users using sql?
Which language is used in sql?
How is data stored in sql?
Is it important to partition hard disk?
what are the nonstandard string types? : Sql dba
Can we write ddl statements in functions?
What is the primary key?
Why do you partition data?
Can we insert data into view?
How do we use distinct statement? What is its use?