how to select sql max function value PLUS another cell from same record?

[omar999]

I can use the select sql max function with no problems;

this is my code

SELECT MAX(Bid_Amount) AS LargestBidAmount FROM Auction_1
 

then to output using asp

Response.Write "<td class=""numbertd"">" & objRS("LargestBidAmount") & "</td>"
 

but how do I also select another cell data [in my case 'name'] from the same record?


would it be something like this....?;

SELECT Name, MAX(Bid_Amount) AS LargestBidAmount FROM Auction_1 UNION SELECT NAME From Auction_1
 

thanks in advance
Omar.

[ck9663]

You're going to have to rejoin it to your table. Try something like:

 
select * from Auction_1
where bid_amount = (SELECT MAX(Bid_Amount) FROM Auction_1)
 
 

This will get all records with the highest amount. Just in case there are "ties" :)

Happy Coding!!!

~~ CK

[omar999]

this worked a treat !

your a life saver - thank you : )