From: Neil Tompkins
Date: December 14 2012 9:28am
Subject: Get lowest value
List-Archive: http://lists.mysql.com/mysql/228813
Message-Id: <CADa_cYrrO8j1F8YQBdWO+TDsavzVV1JMDbgaf13ger0v4FjUNw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b66f73d9e1f1a04d0cca61f

--047d7b66f73d9e1f1a04d0cca61f
Content-Type: text/plain; charset=ISO-8859-1

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

--047d7b66f73d9e1f1a04d0cca61f--