
Finding duplicate values in a table
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 patientfrom proceduresgroup by patientwhereprocedure = ‘X-ray’having count(*) > 1