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 subquery faster than join?

953

What is the function that is used to transfer a pl/sql table log to a database table?

953

Which is faster count (*) or count 1?

968

Why do we use joins?

986

What is a behavioral trigger?

932

Explain the working of foreign key?

977

How do I partition a table in sql?

1045

What is query execution plan in sql?

1130

What are the advantages of pl sql?

1074

Can you call pl/sql package functions from within a fast formula?

977

What are some emotional triggers?

930

Can a composite key be null?

912

What does desc stand for?

1021

how to dump a table to a file with 'mysqldump'? : Sql dba

983

Can we commit in trigger?

923