Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / khandu shinde
select a.sal
from (
select sal ,rownum no
from (
select distinct sal
from emp
order by sal desc
)
) a
where a.no=2
| Is This Answer Correct ? | 16 Yes | 6 No |
Post New Answer View All Answers
How do I run a sql script?
What are sql functions? Describe the different types of sql functions?
Where do we use pl sql?
What is the execution plan in sql?
what is the difference between where clause and having clause? : Sql dba
What is the mutating table and constraining table?
Why do we create stored procedures & functions in pl/sql and how are they different?
List different type of expressions with the example.
What does the file extension accdb stand for?
What is the difference between pl and sql?
Is pl sql better than sql?
What is the use of %rowtype?
How to display Row Number with Records in Oracle SQL Plus?
Can one improve the performance of sql*loader? : aql loader
Is primary key a clustered index?