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

How a tablespace is related to data files?

664

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1888

What is a cursor variable?

660

Explain the use of record option in exp command.

628

What are the varoius components of physical database structure of oracle database?

651

candidate key is subset of super key but not vice-verse explain

1664

What is a read write transaction in oracle?

706

Respected sir, Please send me technical questions related to oracle apps..

1459

What is an anonymous block?

724

What is MTTR advisor in Oracle?

694

what is the use of system.effective.date variable in oracle?

759

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1564

How to convert numbers to characters in oracle?

659

Difference between inner join vs where ?

693

What is meant by raw datatype?

681