select salary from(select salary,rownum rk from(select salary from employee

Query for second maximum salary in each in each department

Question Posted / yaswanth

Answer Posted / yaswanth

select salary from(select salary,rownum rk from(select salary from employees order by salary desc)) ehere rk=2;

Is This Answer Correct ?

2 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Define concurrency control. : Transact sql

1193

What is the use of sqldataadapter?

976

What is the difference between delete and truncate statement in sql?

1074

Does truncate need commit?

948

What is a common use of group by in sql?

1051

What is difference between cursor and trigger?

1083

What is the usage of when clause in trigger?

1057

what is datawarehouse? : Sql dba

1023

What is the current version of postgresql?

1070

What is the difference between microsoft access and sql?

1029

is it possible to pass an object or table to a procedure as an argument?

1135

What is union?

1173

What is the difference between truncate and drop statements?

1190

what are the difference between clustered and a non-clustered index? : Sql dba

1033

Can a table have no primary key?

1064