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
16613 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

Which are the different case manipulation functions in sql?

1076

How do you create a unique index?

1092

Is mariadb nosql?

1090

What's the difference between inner join and left join?

1039

What is synonyms?

1118

What is normalization in a database?

1197

What is procedure in pl sql?

1087

How do I write a sql query in pgadmin 4?

1045

Can we delete column in sql?

1172

Can we use having without group by in sql?

1048

how to use in conditions? : Sql dba

1060

What are % type and % rowtype?

1081

What is sql catalog?

1067

Is oracle and sql same?

1077

How many types of sql are there?

1045