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
how to return query output in html format? : Sql dba
What is meant by truncate in sql?
Is sql the best database?
How to start oracle sql developer?
How do you remove duplicate records from a table?
What is varray in pl sql?
Is it possible to update views?
Explain ddl statements in pl/sql?
what is text? : Sql dba
how is exception handling handled in mysql? : Sql dba
What is sql exception?
What is difference between hql and native sql?
What is the difference between microsoft access and sql server?
What is primary key and foreign key with example?
What does desc stand for?