get a lowest price
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
|