Find out the 3rd highest salary?

Answer Posted / a.jyothsna

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

Is This Answer Correct ?    100 Yes 45 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rtm stands for?

746


What found sql?

703


What is difference between ms sql and mysql?

666


What is the purpose of the sql select top clause?

738


What is normalization? How many normalization forms are there?

747






How exception handling is done in advance pl/sql?

672


What is null in pl/sql?

812


Why do we use partitions in sql?

722


What is scalar data type in pl sql?

788


What is varchar used for?

750


What are the benefits of pl/sql packages?

739


How many triggers can be applied on a table?

672


Are pl sql variables case sensitive?

770


what is the different between now() and current_date()? : Sql dba

703


Is sql a backend language?

844