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


Please Help Members By Posting Answers For Below Questions

What are different types of queries in sql?

525


Why do we use procedures in sql?

550


Explain exception handling in pl/sql?

534


Is a secondary key the same as a foreign key?

492


What is pl sql commands?

558






How to add, remove, modify users using sql?

560


Which language is used in sql?

520


How is data stored in sql?

551


Is it important to partition hard disk?

536


what are the nonstandard string types? : Sql dba

608


Can we write ddl statements in functions?

569


What is the primary key?

538


Why do you partition data?

536


Can we insert data into view?

527


How do we use distinct statement? What is its use?

556