比如查找patient_id,对应的code_id分别等于1,2,3
select distinct patient_id
from qs_patient_code
WHERE code_id = 1
or code_id = 3
or code_id = 2
GROUP BY patient_id
HAVING count(*)>=3
select distinct patient_id
from qs_patient_code
WHERE code_id = 1
or code_id = 3
or code_id = 2
GROUP BY patient_id
HAVING count(*)>=3