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
What is dynamic sql in pl sql?
Where can I learn sql for free?
What is the non-clustered index in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
how to use in conditions? : Sql dba
Define union, minus, union all, intersect ?
What is difference between stored procedures and application procedures?
Is ms sql is free?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
How can you tell the difference between an index and a view?
Can unique keys be null?
Name the different types of indexes in sql and define them.
How do you pronounce sql?
Can primary key be changed?
What are the syntax and use of the coalesce function?