SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
Search
Sunday, October 26, 2008
Finding Duplicates with sql
Subscribe to:
Post Comments (Atom)
Blog Archive
Page view
Labels
- ASP (3)
- auto increment (1)
- auto number (1)
- C++ (2)
- cisco (1)
- curl (1)
- Data SQL SERVER (1)
- database (7)
- datacom (1)
- design (7)
- drupal (1)
- engine (1)
- examples (2)
- Framework (1)
- Gmail (3)
- gridview (1)
- Hi5 (1)
- interesting history (1)
- Java (1)
- javascript (3)
- Joomla (2)
- jquery (2)
- Labs (1)
- linux (1)
- mysql (3)
- Netbeans (2)
- PHP (10)
- php function (2)
- php script (2)
- Replace Text (1)
- ResearchURL (1)
- script (1)
- search (1)
- search engine (1)
- Setup File (1)
- sms (4)
- social community network (3)
- spanning tree (1)
- sql (1)
- SQL SERVER (1)
- switch (1)
- translate (1)
- vista (1)
- Webservice (3)
- wysiwyg editor asp.net (2)
- xml (1)
- บริษัท (1)
- มุมสงบ (4)
- เรื่องเล่าจาก email (1)
- ่joomla (1)
0 comments:
Post a Comment