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

8 Answers
9550 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why does Oracle not permit the use of PCTUSED with indexes?

2419

defination of bitmap index

2117

What are a cluster and non-cluster index?

1018

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

2181

How to resolve the ORA-39133 error in Oracle?

1106

How to create a table index in oracle?

1132

What do you mean by group by clause?

1042

How a database is related to tablespaces?

1030

How to check database size in Oracle?

1186

What happens to indexes if you drop a table?

1167

How to view all columns in an existing table?

932

What is index-organized table in Oracle?

1067

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2172

Difference between oracle's plus (+) notation and ansi join notation?

1098

Give the various rollback segment states.

1048