if my table hav this


item_no, u.price
a0001 9.70
a0001 9.36
a0001 10.00
a0002 5.30
a00002 10.30


i need to get this result

item_no u.price
a0001 9.36
a0002 5.30


i need to get lowest u.price of the item, may i know what SQL transact Command can be used


thq

SELECT Item_No, Min(price)
FROM MyTable
Group By Item_No
Order By Item_No