Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102614 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
How do sql triggers work?
What is a pragma statement?
Is crud a cuss word?
Why use triggers in sql?
What is the advantage of nosql?
What are the two virtual tables available at the time of database trigger execution?
How do I run a sql query?
Why is sql important?
What is the difference between local variables and global variables?
What is rank dense_rank and partition in sql?
What is difference between pls_integer and integer?
Is a table valued function object?
What is lookup table in sql?
How do you get column names only for a table (sql server)?
How many sql statements are used? Define them.
