Thanks guys... These queries did the trick!
> -----Original Message----- > From: Jeff [mailto:jeff@;hawkandheron.com] > Sent: Sunday, November 03, 2002 11:01 AM > To: CF-Talk > Subject: RE: Query help > > Try this... > > SELECT Image1, Description > FROM cars > WHERE rating = (SELECT MAX(rating) FROM cars) > > HTH, > > Jeff Garza > > -----Original Message----- > From: Chad [mailto:cgray@;careyweb.com] > Sent: Sunday, November 03, 2002 8:54 AM > To: CF-Talk > Subject: Query help > > > I know I have done this in the past, but I cannot figure it out for some > reason. > > I want to grab out of a database the record with the highest value for > the field RATING (it is an INT). I also want to grab all the data for > the record like Image1, Description etc.... > > > SELECT MAX(RATING), Image1, Description > FROM cars > WHERE approved = 1 > > Something is very wrong with my select statement.. I cant figure out if > I have to do a MAX(RATING) AS MaximumRATING, Image1, Description... > > > Need more coffee! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
