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

Please explain drop constraint oracle?

1029

Where is the export dump file located?

1082

How to define an anonymous procedure without variables?

1025

How to view the data files in the current database?

1045

How do we represent comments in oracle?

1003

Explain an exception and its types?

1011

What is user managed backup in Oracle?

1078

Why do we need integrity constraints in a database?

973

Explain the use of record length option in exp command.

1026

Can you assign multiple query result rows to a variable?

933

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2309

How to use null as conditions in oracle?

1003

What is rowid and rownum in oracle?

954

What is sharded cluster?

926

How to run create database statement?

979