MySQL Forums
Forum List  »  Newbie

Re: max function
Posted by: Tom Melly
Date: October 05, 2009 12:12PM

It's worth noting that your version will return more than one product if you have to or more products with the same max price.

Also... you want simple?
select product, price
  from products
  order by price desc
  limit 1;

Options: ReplyQuote


Subject
Written By
Posted
October 05, 2009 11:49AM
October 05, 2009 11:49AM
October 05, 2009 12:01PM
October 05, 2009 12:01PM
October 05, 2009 12:08PM
Re: max function
October 05, 2009 12:12PM
October 06, 2009 08:57PM
October 07, 2009 04:09AM
October 07, 2009 05:06AM
October 07, 2009 05:48AM
October 07, 2009 06:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.