Posted by: scoopseven 16 years, 3 months ago
#find duplicates select columnlist, count( duplicate_column) from table group by duplicate_column having count( duplicate_column) > 1 #find duplicates - show both records for comparison SELECT table.* FROM table inner join (select * from table group by duplicate_column having count(*)>1) as temp on table.duplicate_column = temp.duplicate_column Share on Twitter Share on Facebook
Recent Tweets
-
@mashable
@Pete Cashmore
How unequal is wealth in the U.S.? @Charlie_White found this viral video that will astonish you: http://t.co/tgTKMoljnW11 years, 1 month ago -
@scoopseven
@Mark Kecko
"That pizza was great, but probably fattening as tarnation." @innerpeaceLMT @ccchiodo11 years, 1 month ago -
@scoopseven
@Mark Kecko
@MattioV You know it's bad when you're volunteering yourself for busy work. "I have some import statements to clean up, take me a few days."11 years, 2 months ago
Recent Posts
- Django: Unknown command: 'test'
- Granola
- Export Zinna - Import Mezzanine
- Apache Enable Directory Browsing (Indexes) in Arch Linux
- Python/Django Tips n' Tricks Cheatsheet
Archive
2013
2012
2011
2010
- December (1)
2009
2008
2007
2006
Categories
- Apache (5)
- Apple (2)
- ColdFusion (23)
- Database (3)
- Django (20)
- DNS (1)
- IIS (5)
- jQuery (1)
- Linux (13)
- Mac (1)
- MediaPost (14)
- MySQL (15)
- PHP (1)
- Python (10)
- Recipes (1)
- Sphinx (2)
- Tools (2)
- Windows (1)
- WordPress (4)
Authors
- scoopseven (81)