Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118149 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 oltp (online transaction processing)? : Sql dba
How can a function retun more than one value in oracle with proper example?
How many developers work on postgresql?
Does pl/sql support create command?
what are the differences between char and varchar? : Sql dba
Can we use pl sql in sql server?
What are different types of statements supported by sql?
What is difference between table and view?
Is subquery faster than join?
Who developed sql?
What does truncate mean in sql?
How do you update a value in sql?
How are sql commands classified?
Does sql require a server?
Why truncate is used in sql?
