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


Please Help Members By Posting Answers For Below Questions

Can we use update in sql function?

569


what is transaction? : Sql dba

524


What does varchar include?

514


What are some emotional triggers?

565


How do I find duplicates in the same column?

525






What is pl sql block in dbms?

522


Can a key be both primary and foreign?

503


What is difference between ms sql and mysql?

471


What is dynamic query?

529


does sql support programming? : Sql dba

603


Are stored procedures faster than dynamic sql?

523


How do you update a sql procedure?

517


How do you write an inner join query?

502


What is the maximum number of rows in sql table?

535


Is sql developer case sensitive?

510