Ask Your Question
0

Same Fields SQL

asked 2016-03-29 06:00:33 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I need help with a query/subquery: I'm trying to find duplicate patients, where 3 fields are the same: PATIENTNAME=PATIENTNAME AND BIRTHDATE=BIRTHDATE AND DIAGNOSEDATE=DIAGNOSEDATE , like these: 1) John, 01/01/2001, 01/09/2010 2) John, 01/01/2001, 01/09/2010 3) Doe, 09/01/2001, 01/01/2015 4) Doe, 09/01/2001, 01/01/2015 and so on. Thank you, very much!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-03-29 23:54:22 +0100

m.a.riosv gravatar image

I think it's explained in:

http://stackoverflow.com/questions/25...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-29 06:00:33 +0100

Seen: 111 times

Last updated: Mar 29 '16