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

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2003

How will you differentiate between varchar & varchar2?

1006

How would you best determine why your MVIEW couldnt FAST REFRESH?

1856

Are truncate and delete commands same? If so why?

1095

Explain about the analyze command in oracle?

1014

How to write a left outer join with the where clause in oracle?

1043

What is a procedure in oracle?

1104

What is the difference between primary key and unique key and foreign key in oracle?

937

What happens to the current transaction if a ddl statement is executed?

966

How to use like conditions in oracle?

1009

Explain about achiever in sql?

988

What is SQL Tuning Advisor in Oracle?

1125

How many types of segments in Oracle?

1031

How do I uninstall oracle 11g?

1066

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

1000