Find out the 3rd highest salary?

Answer Posted / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Is This Answer Correct ?    17 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cursor in pl sql with examples?

674


Is like operator in sql case sensitive?

734


Can you have a foreign key without a primary key?

681


Is pl sql better than sql?

719


How do I restart sql?

723






how to return query output in html format? : Sql dba

850


Why do we use procedures in pl sql?

721


What do you mean by dbms? What are its different types?

746


What is pivot table in sql?

739


Define select, insert, create, delete, update, drop keywords

776


What is varchar data type in sql?

715


What is duration in sql profiler trace?

774


Can a foreign key have a different name?

695


How does cross join work in sql?

706


what happens if null values are involved in expressions? : Sql dba

736