Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 103203 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / venkat
select max(sal) from emp where sal<(select max(sal) from
emp);
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is sql select statement?
What is sql profiling in oracle?
What is t sql used for?
what is the use of set statement in tsql? : Transact sql
what is oracle database ? : Sql dba
Which software is used for pl sql programming?
What is not equal in sql?
what are the 'mysql' command line options? : Sql dba
Can there be 2 primary keys in a table?
What is pl sql commands?
What does the sign mean in sql?
Show the two pl/sql cursor exceptions.
What is dialect in sql?
Can we join 3 tables in sql?
how to select first 5 records from a table? : Sql dba
