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
Explain foreign key in sql?
Does sql*plus have a pl/sql engine?
What are the types pl/sql code blocks?
Is sql free?
What does an inner join do?
what is bcp? When does it used? : Sql dba
What is record data type?
Can you do multiple joins in sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What are database links used for?
what is datawarehouse? : Sql dba
Explain the select statement in sql?
Which nosql database is best?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are tables in sql?