how to check the 3rd max salary from an employee table?
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
What are the properties of a transaction?
What are the types of triggers in sql?
Does sql backup shrink transaction log?
What are the ddl commands?
Is primary key clustered or nonclustered?
What is sql profiler in oracle?
Name the operator which is used in the query for pattern matching?
Explain spool.
What is the requirement of self-join?
What are aggregate functions in sql?
Why functions are used in sql?
How to use boolean type in select statement?
How to rename a column in the output of sql query?
What is crud stand for?
What does partition by mean in sql?