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 aggregates" at http://www.artfulsoftware.com/queries.php. PB
Thanks Neil
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
