Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102901 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / wei
The best answer should be the first one, this is because
the sql statement accesses table emp only once.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
Explain the insert into statements in sql?
Is postgresql a nosql database?
What is rownum and rowid?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
how to check server status with 'mysqladmin'? : Sql dba
What is data manipulation language?
What is mutating table error?
What is a Mapplet?
What is sqlite used for?
What is java sql drivermanager?
What is an emotional trigger?
what is a constraint? Tell me about its various levels. : Sql dba
what are all types of user defined functions? : Sql dba
Why do we need pl sql?
What is the sql*loader? : aql loader
