 |
| |
 |
|
|
 |
  | LinkBack | Thread Tools | Display Modes |
24-12-08, 03:33 PM
| #1 (permalink) |
| Junior Member Join Date: Dec 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1  |  finding records with duplicate emails I'm trying to find records in an employee DB that have matching email addresses The below SQL returns duplicate email addresses and count. How may I get a list with EMP.Name and email address of those with matching email addresses? SELECT EMP.EMAIL_ADDRESS, COUNT (EMP.EMAIL_ADDRESS) AS NumOccurences FROM EMP GROUP BY EMP.EMAIL_ADDRESS HAVING ( COUNT(EMP.EMAIL_ADDRESS) >1 ) |
 Offline
|  |
|
| Tags |
| duplicate , emails , finding , records |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
 
Similar Threads  | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mega Free Download S/W Links A-Z | yathish | OTHERS | 516 | 21-03-09 10:06 AM |
| How to remove the duplicate records | ShivaniX | Cobol | 0 | 29-05-08 03:22 AM |
| In the source, if we also have duplicate records and | Shailu07 | Informatica | 0 | 01-05-08 01:02 PM |
| How To Delete duplicate records in the emp table? | radhika743 | ORACLE , SQL SERVER , SYBASE & Others | 1 | 05-12-07 12:20 PM |
| Need SQL to find duplicate records? | sk_kireeti | ORACLE , SQL SERVER , SYBASE & Others | 2 | 08-04-06 06:28 AM |
| More Interview Questions Here... |
Linear Mode
