Find out the 3rd highest salary?
Answer Posted / srikanth
select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)
Is This Answer Correct ? | 17 Yes | 10 No |
Post New Answer View All Answers
What is cursor in pl sql with examples?
Is like operator in sql case sensitive?
Can you have a foreign key without a primary key?
Is pl sql better than sql?
How do I restart sql?
how to return query output in html format? : Sql dba
Why do we use procedures in pl sql?
What do you mean by dbms? What are its different types?
What is pivot table in sql?
Define select, insert, create, delete, update, drop keywords
What is varchar data type in sql?
What is duration in sql profiler trace?
Can a foreign key have a different name?
How does cross join work in sql?
what happens if null values are involved in expressions? : Sql dba