select * from emp where sal = (select max(sal) from emp where sal<>(s

how to find out second largest value in the table

Question Posted / anandh

8 Answers
9540 Views
I also Faced
E-Mail Answers

Answer Posted / anandh

select * from emp where sal = (select max(sal) from emp where sal<>(select max(sal) from emp));

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a new tablespace in oracle?

979

What happens to the current transaction if the session is killed?

984

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2336

Why is oracle database so popular?

989

What are the built-in functions used for sending Parameters to forms ?

3380

What are the differences between date and timestamp in oracle?

1044

Point out the difference between user tables and data dictionary?

978

What do you understand by a database object?

1055

How to drop a stored procedure in oracle?

1051

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2260

How to use "in out" parameter properly?

1044

How to connect asp pages to oracle servers?

1069

How to rollback the current transaction in oracle?

1049

How do I know if oracle client is installed on windows?

1019

How to use "out" parameter properly?

1078