select max(sal) from emp where sal<(select max(sal) from emp)

how to get second highest sal of emp table

Question Posted / yadunandan

Answer Posted / yadunandan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain integrity constraints?

1164

How to divide query output into groups in oracle?

1044

How to load data from external tables to regular tables?

1114

How does Oracle guarantee data integrity of data changes?

2461

Explain do view contain data?

1052

Explain the types of exception?

1201

How to sort the query output in oracle?

1078

What is a nvl function? How can it be used?

1105

What is bind variable in oracle 11g?

1101

How do we display rows from the table without duplicates?

1023

How to end the current transaction in oracle?

1081

What are the ways tablespaces can be managed and how do they differ?

2461

Please explain compound trigger in oracle?

1115

Explain table?

1183

What is a sub query and what are the different types of subqueries?

1183