List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:December 14 2012 9:28am
Subject:Get lowest value
View as plain text  
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

Thread
Get lowest valueNeil Tompkins14 Dec
  • RE: Get lowest valueAdrian Espinosa Moreno14 Dec
  • Re: Get lowest valuePeter Brawley14 Dec