List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:December 14 2012 4:00pm
Subject:Re: Get lowest value
View as plain text  
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
>

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