Find out the 3rd highest salary?
Answer Posted / kaushal kassi
select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)
Is This Answer Correct ? | 24 Yes | 12 No |
Post New Answer View All Answers
Can we use update in sql function?
what is transaction? : Sql dba
What does varchar include?
What are some emotional triggers?
How do I find duplicates in the same column?
What is pl sql block in dbms?
Can a key be both primary and foreign?
What is difference between ms sql and mysql?
What is dynamic query?
does sql support programming? : Sql dba
Are stored procedures faster than dynamic sql?
How do you update a sql procedure?
How do you write an inner join query?
What is the maximum number of rows in sql table?
Is sql developer case sensitive?