select sal from table where rownum = 2 order by sal desc

How to Select second Maximum salary in a Table ?

Question Posted / havyas

Answer Posted / havyas

Is This Answer Correct ?

1 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Can select statements be used on views in oracle?

1082

How data locks are respected in oracle?

1108

What is a tns service name?

1055

How to define a variable of a specific record type?

1113

How do I find my oracle client driver version?

1092

What is the difference between postgresql and oracle?

1101

How to install oracle odbc drivers?

1137

IS it possible to built the oracle database without setting the kernal parameters?

2393

How is it different from a normal table?

1081

What is a proxy object?

1103

How remove data files before opening a database?

1132

What privilege is needed for a user to insert rows to tables in another schema?

1056

What is a select query statement in oracle?

1025

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4230

What are the different windows events activated at runtime ?

2941