NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
'''Victim First name, Last name and Date of birth''' This query may need to be adopted if the country use CDFs or ''Age''
<pre>
SELECTDISTINCT d.victim_guid trimFROM victim AS b INNER JOIN victim AS d ON TRIM(UPPER(victimb.givennamefamilyname)),trim= TRIM(UPPER(victimd.familyname),) AND victim.dateofbirth,CountTRIM(UPPER(victimb.victim_guidgivenname))FROMvictimGROUP BYtrim= TRIM(UPPER(victimd.givenname),) AND trim(victimb.familyname),victimdateofbirth = d.dateofbirthHAVINGCount(victimWHERE b.victim_guid) <> '1'ORDER BYtrim(victimd.givenname) ASC,trim(victim.familyname) ASC,victim.dateofbirth ASCvictim_guid</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
