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

What is transport network substrate (tns) in oracle?

1091

What is the difference between view and materialized view in Oracle?

1206

How to create a testing table in oracle?

1032

What is a data lock in oracle?

1180

Write a syntax for update query in oracle?

1073

How to assign values to variables?

1163

What is a private synonym?

1644

In the oracle version 9.3.0.5.0, what does each number shows?

1344

what is the difference between functional dependecy and multilevel dependency?

2519

What are the arithmetic operations?

1149

How to delete a user account in oracle?

1021

Why use resource manager in Oracle?

1172

Calculate difference between 2 date / times in oracle sql?

1097

How to add a new column to an existing table in oracle?

1186

What are the restrictions on external table columns?

1109