select * from (select a.*,dense_rank() over (order by sal) rnk from emp a o

how to find the second highest salary from emp table?

Question Posted / dakshin

Answer Posted / dakshin

select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why we use join in sql?

966

what is commit? : Sql dba

1069

What are synonyms in sql?

970

What is range partitioning?

962

What is pl/sql table? Why is it used?

1037

How would you convert date into julian date format?

1002

What is difference between stored function and application function?

1195

What is trigger price?

984

What is procedure function?

1052

what is collation? : Sql dba

1148

Why schema is used in sql?

1047

How can a function retun more than one value in oracle with proper example?

1074

What is a primary key? Explain

972

How do I find duplicates in the same column?

1082

What is scope of pl sql developer in future?

1018