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

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

Please Help Members By Posting Answers For Below Questions

How to import one table back from a dump file?

585

Is oracle the best database?

518

Explain oracle left join with an example?

579

In what script is snap$ created? In what script is the scott/tiger schema created?

2240

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1652

What is tns service name?

612

How can you merge two tables in oracle?

565

How do I start tns listener?

538

How much memory your 10g xe server is using?

578

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1691

How to convert characters to times in oracle?

592

What is the relation of a user account and a schema?

611

What is the difference between substr & instr functions?

595

What is the Tune Query

1837

How to enter a new row into a table interactively?

544