select * from(select row_number() over(partition by deptno order by sal des

Query for second maximum salary in each in each department

Question Posted / sureshramsing

Answer Posted / sureshramsing

select * from(select row_number() over(partition by deptno order by sal desc) rn,a.* from emp a) where rn=1;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

explain the difference between delete , truncate and drop commands? : Sql dba

1015

Are subqueries faster than joins?

949

Does pl sql work in mysql?

919

What is the use of & in pl sql?

985

How do I run a pl sql procedure in sql developer?

912

Is it possible to sort a column using a column alias?

991

How would you reference column values before and after you have inserted and deleted triggers?

1016

How to assign sql query results to pl sql variables?

991

Write a sql select query that only returns each name only once from a table?

959

What is rownum and rowid?

983

What is the difference between an inner and outer join?

960

What is crud stand for?

931

What is an exception in pl/sql?

1005

What is application trigger?

945

What are user defined functions?

947