Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120088 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
Why are aggregate functions called so?
Why is nosql good?
What is the difference between inner join and outer join?
How do I partition a table in sql?
What is sqlcommand?
How do you create an update query?
what is denormalization. : Sql dba
what is bdb (berkeleydb)? : Sql dba
How do I remove sql developer from windows 10?
what are local and global variables and their differences? : Sql dba
How do I copy a table in sql?
What is foreign key in sql with example?
What does where 1 1 mean in sql?
What is sqlite format?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
