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

find out the second highest salary?

Question Posted / prasant

55 Answers
88295 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / prasant

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

MAX(SAL)
----------
3000

Is This Answer Correct ?

22 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the characteristics of data files?

1046

How to use group functions in the select clause using oracle?

1040

How to initialize variables with default values?

1186

What is coalesce function?

1031

How to write a query with a right outer join in oracle?

1132

How many file formats are supported to export data?

1161

How to view the data files in the current database?

1056

How can we delete duplicate rows in a table?

944

What is meant by an index?

1079

Can we save images in a database and if yes, how?

1012

What is a package ? What are the advantages of package ?

1051

what is the difference between data migration and production migration.

2291

How to save query output to a local file?

988

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1920

What is connection pooling in oracle?

929