select * from VIEWRESIDENTHIST
where patientId = 52 and (VISIT_DATE,sourceTable) in (select MAX(VISIT_DATE) as VISIT_DATE,sourceTable from VIEWRESIDENTHIST where patientId = 52 GROUP BY patientId,sourceTable)
select * from VIEWRESIDENTHIST
where patientId = 52 and (VISIT_DATE,sourceTable) in (select MAX(VISIT_DATE) as VISIT_DATE,sourceTable from VIEWRESIDENTHIST where patientId = 52 GROUP BY patientId,sourceTable)