select max(sal) from table_name where sal<(select max(sal) from table

How to Select second Maximum salary in a Table ?

Question Posted / tanuj tewari

Answer Posted / tanuj tewari

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

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is tns name?

732

Can we store images in oracle database?

741

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

750

What is a database schema in oracle?

851

Give the advantages and disadvantages of clusters.

781

How to connect to a local oracle 10g xe server?

716

What is a snapshot log?

761

Will you be able to store pictures in the database?

865

Can we insert data in view oracle?

734

What is a partition in oracle?

775

How to apply filtering criteria at group level in oracle?

798

What are the uses of a database trigger?

697

What is rich query?

716

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1728

Explain integrity constraint?

870