select * from ( select * from test where sal

how to find out second largest value in the table

Question Posted / vishal

Answer Posted / vishal

select * from (
select * from test where sal < (select max(sal) from test)
order by 2 desc)
where rownum =1

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is partitioned table in Oracle?

1191

Give the advantages and disadvantages of clusters.

1052

How to create a new oracle data file?

1033

How to store only time; not date and time?

1021

How to assign a table row to a record variable?

1043

How to run create database statement again?

1160

How to start your 10g xe server?

1045

What is Data Dictionary Cache in Oracle?

1168

What is tns entry?

1156

Can group functions be used in the order by clause in oracle?

999

How to manage transaction isolation level?

1007

How to turn on or off recycle bin for the instance?

1085

What is flashback in Oracle?

1022

What are a collation and state the different types of collation sensitivity?

1173

How do you store pictures in a database?

1008