select * from emp where sal = (select max(sal) from emp where sal<>(s

how to find out second largest value in the table

Question Posted / anandh

Answer Posted / anandh

select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between 10g OEM and 11g OEM?

628

How to do clean up if create database failed?

667

defination of bitmap index

1715

What is private procedure oracle?

604

What are the database administrators utilities available?

662

What is ADDM Advisor in Oracle?

761

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

685

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

2927

Explain the difference between sap and oracle?

655

What privilege is needed for a user to create indexes in oracle?

666

Which is better Oracle or MS SQL? Why?

5622

Where are the settings stored for each instance in oracle?

736

What are the different pseudo commands? Explain in general?

658

Explain the use of grant option in exp command.

669

How to increment dates by 1 in oracle?

652