Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find out second largest value in the table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of merge statement?

1205


How do you store pictures in a database?

1060


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1089


How to install oracle odbc drivers?

1145


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114


What is the difference between alert log file and tarce file ?

2232


Explain about functional dependency and its relation with table design?

1061


How can we find out the duplicate values in an oracle table?

1121


How to sort the query output in oracle?

1076


How to run create database statement?

1081


How to define an explicit cursor in oracle?

1102


How to do a full database export?

1153


what are bitmap indexes? How does they work?

2307


When do you get a .pll extension in oracle?

1193


What suggestions do you have to reduce the network traffic?

1021