Re: Get lowest value

2012-12-14 Thread Peter Brawley
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

RE: Get lowest value

2012-12-14 Thread Adrian Espinosa Moreno
[mailto:neil.tompk...@googlemail.com] Enviado el: viernes, 14 de diciembre de 2012 10:28 Para: [MySQL] Asunto: Get lowest value 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 ne

Get lowest value

2012-12-14 Thread Neil Tompkins
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 ? Thanks Neil