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

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2478

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1799

Who developed oracle & when?

653

What is truncate oracle?

605

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1886

How to assign values to variables?

679

What suggestions do you have to reduce the network traffic?

631

Explain joins in oracle?

626

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1734

How to use attributes of the implicit cursor in oracle?

651

How to delete a column in an existing table?

687

What happens if variable names collide with table/column names?

682

What is the difference between sharding and replication?

566

How to write date and time literals in oracle?

633

what is the use of system.effective.date variable in oracle?

755