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

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

850


What is meant by truncate in sql?

752


Is sql the best database?

672


How to start oracle sql developer?

753


How do you remove duplicate records from a table?

679






What is varray in pl sql?

765


Is it possible to update views?

713


Explain ddl statements in pl/sql?

736


what is text? : Sql dba

779


how is exception handling handled in mysql? : Sql dba

769


What is sql exception?

705


What is difference between hql and native sql?

777


What is the difference between microsoft access and sql server?

713


What is primary key and foreign key with example?

687


What does desc stand for?

788