Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120106 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / deepa
select min(salary) from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the different set operators available in sql?
How do I remove duplicates in two columns?
Which one is better subquery or joins?
Why should I use postgresql?
What is int identity in sql?
Why is sql important?
Can you selectively load only those records that you need? : aql loader
Why do we use partitions in sql?
Which join is like inner join?
Is left join inner or outer?
How do I run a sql query in pgadmin 4?
What are string functions in sql?
what are myisam tables? : Sql dba
Is left join faster than join?
what are rollup and cube in t-sql? : Transact sql
