Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102788 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
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 is the limitation on the block size of pl/sql?
Why do we use %rowtype & %type in plsql?
how to create a new table in mysql? : Sql dba
What is rank dense_rank and partition in sql?
What is trigger in sql?
Define overloaded procedure?
what is the difference between char and varchar data types? : Sql dba
How exception is different from error?
How can I see all tables in sql?
Can triggers stop a dml statement from executing on a table?
Is sql difficult?
what is a unique key ? : Sql dba
Why do we use partitions in sql?
How many functions are there in sql?
What is primary key secondary key alternate key candidate key?
