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
What is rtm stands for?
What found sql?
What is difference between ms sql and mysql?
What is the purpose of the sql select top clause?
What is normalization? How many normalization forms are there?
How exception handling is done in advance pl/sql?
What is null in pl/sql?
Why do we use partitions in sql?
What is scalar data type in pl sql?
What is varchar used for?
What are the benefits of pl/sql packages?
How many triggers can be applied on a table?
Are pl sql variables case sensitive?
what is the different between now() and current_date()? : Sql dba
Is sql a backend language?