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

find out the third highest salary?

Question Posted / sukanya

Answer Posted / sukanya

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

1034

What is connection pooling in oracle?

973

What is oracle open database communication (odbc)?

1028

Explain about the analyze command in oracle?

1052

What are the built-in functions used for sending Parameters to forms ?

3388

Explain the use of ignore option in imp command.

1035

Can select statements be used on views in oracle?

1027

What is the difference between a primary key & a unique key?

1090

What happens if variable names collide with table/column names?

1191

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

What are the predefined tablespaces in a database?

1082

What are ddl statements in oracle?

1075

Explain oracle instance.

1180

How to execute a stored program unit?

1077

What is the usage of save points in oracle database?

964