Select max(price) from product where price not in (select max(price) from

how to find out second largest value in the table

Question Posted / irshad ahmad

Answer Posted / irshad ahmad

Select max(price) from product where price
not in (select max(price) from product);

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the restrictions on external table columns?

1060

What is the max number of columns in an oracle table?

1004

Explain a data segment?

1076

How to drop an existing view in oracle?

953

Explain oracle insert into command?

1117

How to compare dates in oracle sql?

1112

How to define an oracle cursor variable?

1038

How to create a table interactively?

1100

How to convert characters to dates in oracle?

1107

List out the components of logical database structure of oracle database.

1042

How to create an oracle testing table?

1078

Explain what are the type of synonyms?

1135

Why do you create or replace procedures rather that drop and recreate.

1015

Explain parameter file in oracle.

1036

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4610