7.5 List of possible duplicate patients in the system based on identical names and dates of birth. Jeff Buchbinder

center

FreeMED ptlname AS 'Last Name', ptfname AS 'First Name', ptdob AS 'Date of Birth', count(ptlname) as 'Count' patient ptarchive = 0 ptlname, ptfname, ptdob having count(concat(ptlname, ' ', ptfname, ' ', ptdob )) > 1 'Last Name', 'First Name' 0 0 1 1 1 30 60 left 30 60 left 30 60 left 30 60 left 480 268 1 1 columns

0 0 0

15 0 288 72 11 36 2 10 A3 14 1 1 1 1 1