Question:
I have a table with the following fields:
Physician Patient # Procedure
One of the Procedures is “X-ray.” How can I list the Patient # of anyone who has had more than one X-ray?
Answer:
select patient
from procedures
group by patient
where
procedure = ‘X-ray’
having count(*) > 1