SELECT patient_id,diagnosis FROM admissions 
GROUP BY patient_id,diagnosis 
HAVING COUNT(diagnosis = diagnosis) > 1;