I'm a software developer that has been doing professional web application development with Ruby on Rails. These are my postings of various things that I've figured out and learned that I thought might be helpful.
Thursday, July 30, 2009
MySQL selecting duplicates
SELECT store_id, dated, count(*) as t FROM analytic_daily_summaries GROUP BY store_id, dated HAVING t>1 ORDER BY dated DESC