select * from(select e.*,row_number() over (order by e.salary desc)rn from

how to find the second highest salary from emp table?

Question Posted / vikas

Answer Posted / vikas

select * from(select e.*,row_number() over (order by
e.salary desc)rn from Employee e)where rn between 1 and 2
order by rn

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the usage of the distinct keyword?

1217

What is the difference between unique and primary key constraints?

1069

What are sql constraints?

1172

Could you please provide oca (oracle 10g) dumps for my certification ?

5156

What is the main difference between sql and pl/sql?

1094

What is delimiter sql?

985

What is structural independence and why is it important?

1031

How can one get sql*loader to commit only at the end of the load file? : aql loader

1059

What are the two types of cursors in pl sql?

1075

What is raw datatype in sql?

1042

how to include character strings in sql statements? : Sql dba

1067

What are the different dml commands in sql?

1169

What is interval partition?

1051

what are the types of subquery? : Sql dba

1102

If a cursor is open, how can we find in a pl/sql block?

1165