Write a query to get 2nd maximum salary in an employee table ?
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 aggregate functions are available there in sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Do stored procedures prevent sql injection?
What is nested table in pl sql?
What is the difference between truncate and drop statements?
What is pl sql commands?
What does the hierarchical profiler does?
What are keys in sql?
what is the different between now() and current_date()? : Sql dba
What is function and procedure?
Explain what is table in a database?
What will you get by the cursor attribute sql%notfound?
Explain what is a column in a table?
Why do we use partitions in sql?
what are tables and fields? : Sql dba