Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116127 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 are commit, rollback, and savepoint?
What is crud sql?
Is hadoop a nosql?
What has stored procedures in sql and how we can use it?
What are the limitations of sql express?
What are the types of join and explain each?
What is embedded sql what are its advantages?
How do I view a procedure in sql?
how many ways we can we find the current date using mysql? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
Define the select into statement.
What is where clause in sql?
Can one improve the performance of sql*loader? : aql loader
Explain foreign key in sql?
What is #table in sql?
