The best answer should be the first one, this is because the sql statemen

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / wei

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

Please Help Members By Posting Answers For Below Questions

What is the difference between clustered and non-clustered indexes?

1085

How to make a copy values from one column to another in sql?

1031

What are the different operators available in sql?

1000

What does dml mean?

982

what are the disadvantages of mysql? : Sql dba

1146

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

966

How to check if a column is nullable before setting to nullable?

1121

What is a full join sql?

1054

What is sqlite used for?

988

How do you modify a table in sql?

1118

How do you declare a user-defined exception?

1022

What is the main reason behind using an index?

1013

Does view contain data?

1024

What is rollback?

1110

What is the difference between view and stored procedure?

959