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

Does a join table need a primary key?

1002

how to fetch alternate records from a table? : Sql dba

1172

What is scalar function?

1096

Can you select everything, but 1 or 2 fields, without writer's cramp?

1042

How do you clear the screen in sql?

1124

Can you have more than one trigger on a table?

1049

What does t sql mean?

1004

what are the advantages of using stored procedures? : Sql dba

1157

Is sql a dbms?

1065

What is the maximum number of rows in sql table?

1083

What is user in sql?

1078

What is sql data?

1034

What is orm in sql?

1099

What is denormalization in a database?

1107

What are field types?

1055