Select first_name, salary, rownum rank from (select *from emp order by sa

Query for second maximum salary in each in each department

Question Posted / sravan

Answer Posted / sravan

Select first_name, salary, rownum rank from
(select *from emp order by salary desc)

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Is it possible to create the following trigger: before or after update trigger for each row?

1282

How does join work in sql?

1007

Why stored procedures are faster than query?

1020

What type of database is sql?

1021

What is benefit of creating memory optimized table?

970

What is difference between primary and secondary key?

1022

Is sql free?

955

what is sql? : Sql dba

1021

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1020

What is cascade in sql?

961

Why do we need sharding?

984

Is sql difficult?

1148

What is the difference between join and natural join?

927

what is rdbms? : Sql dba

1012

What is %rowtype in pl sql?

987