select *from emp where sal=(select distinct(max(sal)) from emp where sal &

how to find out second largest value in the table

Question Posted / mk

Answer Posted / mk

select *from emp where sal=(select distinct(max(sal)) from
emp where sal <select max(sal) from emp )

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a new user account in oracle?

657

How to use in conditions in oracle?

661

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

746

How to count groups returned with the group by clause in oracle?

670

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1757

What are a query and state the different types of queries and their uses?

592

What is backup in Oracle?

647

How do I limit the number of rows returned by an oracle query after ordering?

731

How to create a table index in oracle?

743

What are the different types of failures that occur in Oracle database?

699

What is tns name?

631

What is a nested table and how is it different from a normal table?

664

How to use "while" statements in oracle?

816

How to grant create session privilege to a user in oracle?

649

How to retrieve the count of updated rows?

658