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

what is a table in a database ? : Sql dba

1056

What are the types of views in sql?

1110

What is serial sql?

988

What is function and procedure in pl sql?

1059

Is join an inner join?

983

How do I find sql profiler?

951

What is difference between rank () row_number () and dense_rank () in sql?

1119

Does sql full backup truncate logs?

1032

Explain constraints in sql?

1055

What is cursor and why it is required?

1192

What is left join in sql?

1062

Why we use stored procedure instead of query?

1011

What are the types pl/sql code blocks?

1144

What is the max nvarchar size?

994

What do you understand by pl/sql records?

1026