how to check the 3rd max salary from an employee table?
- 23 Answers
- 30065 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / arjun
select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Does sqlite need a server?
How many types of literals are available in pl sql?
How do you truncate?
What is denormalization in a database?
what is cursor. write example of it. What are the attributes of cursor.
What is sql select statement?
How do I turn a list into a table?
What is information schema in sql?
Can ddl statements be used in pl/sql?
Why function is used in sql?
Explain two easy sql optimizations.
How do I delete a trigger?
Explain how to use transactions efficiently : transact sql
Does oracle roll back the transaction on an error?
What is oracle sql called?
