Want to Select Records with Minimum value

Hello,



I would like to select records based on Minimum values of specific vendor.

Example:



MasterItemID Price PriceDate VendorID

1 2 2/5/14 30

1 3 2/5/14 31

1 7 2/5/14 32

2 3 2/5/14 31

2 2 2/5/14 32



So wants the all columns where price is minimum

example: output required

MasterItemID Price PriceDate VendorID

1 2 2/5/14 30

2 2 2/5/14 32



Thanks and waiting of your response.



Rehan

Want to Select Records with Minimum value