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

Who is the owner of mysql database?

1104

What is execute immediate?

1159

What do you mean by stored procedures?

1065

Explain exception handling in pl/sql?

1080

What is dml and ddl?

1007

what is collation? : Sql dba

1198

Why do we use view in sql?

1017

Is sql a dbms?

1059

Can we use commit inside a trigger?

1143

What is query syntax?

1017

What is dynamic query?

1027

What is the difference between python and sql?

1051

what is a database transaction? : Sql dba

1255

What is the difference between microsoft sql and mysql?

1015

What is a system versioned table?

1038