On 2012-12-14 3:28 AM, Neil Tompkins wrote:
Hi,
I've the following data
total, supplier_id, product_name, supplier_code
125,2,iPod,xyz123
100,1,iPod,abc123
145,3,iPod,1213113
245,4,iPod,12345
What query do I need to get the lowest total in this case 100 for
supplier_id 1 ?
See "Within-group
Hi Neil,
Check this documentation, I think you will have no trouble to adapt it to your
code
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_min
--
Adrián Espinosa.
Engineering Support, Wholesale Systems.
Jazztel.com
-Mensaje original-
De: Neil Tompkins [mail
