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
What are the various levels of constraints?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is a composite primary key?
What are the events on which a database trigger can be based?
is mysql query is case sensitive? : Sql dba
Can we call dml statement in function?
How do I kill a query in postgresql?
How can you know that statistics should be updated?
How to combine two stored procedures in sql?
what is the difference difference between procedure and packages
What are the disadvantages of file system?
How to place comments in pl/sql?
Write a unique difference between a function and a stored procedure.
Define implicit and explicit cursors.
Which version of sql do I have?