I have a table (EyeData) that contains the columns patientid, Eye (left or right), enucleation
There can be multiple rows for a patient. There can also be records that have Eye=right and Eye=Left for the same patient.
How would i select the rows where the patient only has rows for left or rows for right? I.e. to put it simply where the patient has only data for one eye.