MySQL Forums
Forum List  »  PHP

Re: How do I display the minimum number in my table?
Posted by: Mohamed Mansour
Date: December 09, 2005 11:17AM

Hi, you can use an aggregate function,
Many functions within MySQL such as

http://dev.mysql.com/doc/refman/5.0/en/functions.html

so:

SELECT MIN(money) FROM bank;


hope it helps

Mohamed Mansour
Software Engineer
Microsoft Student Partner Alumni

Options: ReplyQuote




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.