Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102909 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / lakshminarayana reddy
select rownum,empno,ename,job,sal from emp(select
rownum,empno,ename,job,sal from emp order by sal desc) grop
by rownum,empno,ename,job,sal having rownum=2;
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
What is the location of pre_defined_functions.
What are the disadvantages of not performing database normalization?
Will truncate release space?
How to find 3rd highest salary of an employee from the employee table in sql?
How can you know that statistics should be updated?
Can we insert in sql function?
What is sql deadlock?
What is a constraint?
Which sorts rows in sql?
What is database migration?
How bulk collect improves performance?
How much ram can sql express use?
What is rowid in sql?
What is a sql*loader control file?
explain mysql aggregate functions. : Sql dba
