Find out the 3rd highest salary?
Answer Posted / a.jyothsna
select a.sal
from emp a
where 3=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal)
| Is This Answer Correct ? | 100 Yes | 45 No |
Post New Answer View All Answers
How to add, remove, modify users using sql?
Why primary key is required?
Why commit is not used in triggers?
What is recursive join in sql?
Why do we use joins in sql?
What are sql objects?
What is orm in sql?
What is memory optimized?
When are we going to use truncate and delete?
Does db2 use sql?
Is natural join same as inner join?
How many types of keys are there in sql?
What is the use of function in sql?
how to create a new table in mysql? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba