id User Bid_ID Amount id1 manu bid67 3000 id2 vinu bid68 4000 id3 anu bid67 6000 id4 aju bid68 5500 id5 amal bid80 3500 id6 vinu bid80 8000
id User Bid_ID Amount id3 anu bid67 6000 id4 aju bid68 5500 id6 vinu bid80 8000
SELECT bid_ID, user, MAX(Amount) AS Amount FROM dbo.tbl_BidOffer GROUP BY bid_ID, user
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)