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 percent sign in sql?

1283

What is the use of procedures?

975

what are all the different normalizations? : Sql dba

1038

Is sql the best database?

972

How to pipe multiline string to isql?

1005

What is the purpose of primary key?

1026

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

Is oracel sql developer written in java?

1104

what is meant by urlencode and urldocode? : Sql dba

1174

What does 0 mean in sql?

965

How do I find duplicates in a single column in sql?

1020

what is a table in a database ? : Sql dba

1038

What is delete command in sql?

1110

What is full join in sql?

991

what is transaction? : Sql dba

1007