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?
group by patient
procedure = ‘X-ray’
having count(*) > 1