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

What is sql indexing?

1065

Can you selectively load only those records that you need? : aql loader

1096

Mention what is the use of function "module procedure" in pl/sql?

1090

What is sqlerrm?

987

what happens if null values are involved in expressions? : Sql dba

1093

How to rename a table?

1076

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1126

how do you tune the slow running queries in oracle db , explain the methodology

3236

What is group function in sql?

1067

What is the difference between left join and right join?

990

Where is sql database stored?

1039

What are character functions in sql?

995

What is a function in oracle pl sql?

1098

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1186

How many types of triggers exist in pl/sql?

1137