Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118297 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / priya
select rownum,empno,sal from (select
rownum,empno,sal from emp order by sal desc) group
by rownum,empno,sal having rownum=2;
This will clearly work.............
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
what is the difference between $message and $$message? : Sql dba
What is scope and visibility in PL/SQL?
What is equi join in sql?
Difference between global and parameter variables?
discuss about myisam key cache. : Sql dba
What is partition in sql query?
What packages are available to pl/sql developers?
how to decrement dates by 1 in mysql? : Sql dba
Explain lock escalation? : Transact sql
What are all the common sql functions?
Can we create index on primary key?
Why is sql*loader direct path so fast?
What is embedded sql in db2?
What is data definition language?
How do I edit a trigger in sql developer?
