select sal from emp order by sal desc offset 1 rows fetch next 1 rows with

How to retrieve a second highest salary from a table?
Note:Suppose salaries are in duplicate values
eg:
Name Sal
Malli 60000
Pandi 60000
Rudra 45000
Ravi 45000

Question Posted / ashok

10 Answers
16335 Views
Mind Tree, Polaris, Sonata, I also Faced
E-Mail Answers

Answer Posted / ashok

select sal from emp order by sal desc offset 1 rows fetch next 1 rows with ties;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the maximum number of triggers, you can apply on a single table?

992

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1087

is it possible to pass an object or table to a procedure as an argument?

1129

How to connect a sql*plus session to an oracle server?

1122

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

956

How to rename a table?

1012

How many indexes can be created on a table in sql?

1052

Can we rollback delete command?

980

What is rank function in sql?

1024

When sql appeared?

1093

What is pl sql code?

1047

what is myisam? : Sql dba

1076

What are the query optimization techniques?

932

How many developers work on postgresql?

975

what are the different tables present in mysql? : Sql dba

980