Select Max(sal) from emp where sal < any (select sal from emp);

Query to get max and second max in oracle in one query ?

Question Posted / shashank yadav

34 Answers
65257 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

Answer Posted / shashank yadav

Select Max(sal) from emp
where sal < any (select sal from emp);

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is tns name?

975

How to use select statement to count the number of rows in oracle?

1038

Why is oracle so popular?

990

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1964

What is recycle bin in Oracle?

1142

How do I escape a reserved word in oracle?

1194

What is oracle in java?

959

What is a system tablespace and when it is created?

969

How to open and close an explicit cursor in oracle?

1041

How many categories of data types in oracle?

1024

What are the various types of snapshots ?

1023

What is the data pump export utility?

1077

What is varray?

1124

How to bring a tablespace offline?

1054

Is oracle a relational database?

911