Robert,
If any of the Qty items will do, then either the MAX() or the MIN() Qty will meet your criteria.
SELECT Item, MIN(Qty) FROM MyTable GROUP BY Item
>Hi All,
>
>I have a table containing two fields, Item and Qty. Neither field is uniue. I need to select the distinct list of items from the table, and any one of the 'associated quantities'. Eg:
>
>Item Qty
>A 2
>A 4
>A 6
>B 3
>C 7
>C 9
>
>Results I want are:
>
>A 2 (or 4 or 6)
>B 3
>C 7 (or 9)
>
>Thanks,
>Rob