Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102615 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
What is an inconsistent dependency?
How to process query result in pl/sql?
How do you update f as m and m as f from the below table testtable?
What is a stored procedure in sql with example?
Why do we use procedures in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Where can I learn sql for free?
What is scope of pl sql developer in future?
Which sql statement is used to delete data from a database?
Which one is better sql or oracle?
What are the packages in pl sql?
what is the functionality of the function htmlentities? : Sql dba
What are actual parameters and formal parameters?
What are the types of operators available in sql?
explain advantages of myisam over innodb? : Sql dba
