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

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

What is a nested table?

1007

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

2130

How to rename an index in oracle?

1063

what is the difference between restoring and recovering?

965

What is a trigger and what are its types in oracle?

1000

Which is better Oracle or MS SQL? Why?

6267

what are steps for interface? where is exchange rate defined in which table?

2058

How to write an inner join with the where clause in oracle?

997

How to retrieve the count of updated rows?

1057

How to define a sub function?

1084

What is merge in oracle?

997

How do I use os authentication with weblogic jdriver for oracle and connection pools?

999

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2147

What is flashback in Oracle?

967