Had a bit of fun today, trying to pick out only singleton entries from a database table, finding the lowest unique bid for the reverse auction app i’m doing at work. this is what i came up with:

SELECT *
FROM bids
WHERE auction_id =1
GROUP BY value
HAVING ( COUNT( value ) =1 )
ORDER BY value ASC
LIMIT 1;

This entry was posted on Friday, February 10th, 2006 at 1:46 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.