Find records where dates equal for same ID

[mkallover]

I have a query that I created that finds all the duplicates in a table based on a unique ID. Now what I would like to do is narrow that query down to find only those records where:

1. ID's are equal

AND

2. A field called "SANC_DATE" is equal for those IDs

I don't even know where to start here.

Example:

ID    | SANC_DATE   | END_DATE
------|-------------|------------
53     01-23-2004    12-31-9999
53     01-23-2004    1-23-2006

I would want to only pull those records where ID and SANC_DATE are equal.

 

[PHV]

What is your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[alvechurchdata]

You could group by ID + SANC_DATE, get the count of each group and filter for Count(*)>1.

Geoff Franklin

http://www.alvechurchdata.co.uk