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

Explain oracle insert into command?

1110

How can I see all tables in oracle?

1007

How can we find out the duplicate values in an oracle table?

1043

What is the order of defining local variables and sub procedures/functions?

1058

How to pass a parameter to a cursor in oracle?

1176

How to assign data of the deleted row to variables?

1071

What are dml statements in oracle?

1089

Explain the types of exception?

1143

How to export your own schema?

1007

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2041

Is primary key indexed by default in oracle?

985

How to select all columns of all rows from a table in oracle?

1052

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

1026

Why cursor variables are easier to use than cursors?

1092

How do I learn what codesets are available in oracle?

1036