query to list proxy

[crackon]

need a query to list a proxy bid pls, my colums are

Id
Idproduct
Idcustomerbid
Bidamount

It must list highest bid for each user but not highest bid

 

[gmmastros]

Just a WAG'ing it.

Select YourTableName.*
From   YourTableName
       Inner Join (
         Select idCustomerbid, Max(BidAmount) As MaxBid
         From   YourTableName
         Group BY idCustomerbid
         ) as MaxData
         On YourTableName.idCustomerBid = MaxData.idCustomerbid
         And YourTableName.BidAmount = MaxData.MaxBid

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

What is your SQL Server version?

select * from (select Id, Idproduct, Idcustomerbid, Bidamount, row_Number() over (partition by IdCustomerBid order by BidAmount Desc) as RowNum) OrderedResult where RowNum = 1

 

[crackon]

08

 

[markros]

If you meant SQL Server 2008, then try both versions. If you meant 80 for the version, go with George's solution.