Re: Get lowest value

[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 aggregates" at http://www.artfulsoftware.com/queries.php.

PB

>
> Thanks
> Neil
>