Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118056 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 crud stand for?
what is timestamp in mysql? : Sql dba
What are reports usually used for?
What is sql dialect?
What is range partitioning?
What is the maximum number of triggers, you can apply on a single table?
What are the different types of constraints?
What is record type in pl sql?
What does the sign mean in sql?
What is number function in sql?
What are the advantages of sql?
What does pragma mean?
What are the most important characteristics of pl/sql?
How many commands are there in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
