仅显示除NULL之外的每个组的第一行

I have a table of patients. Patients may be single or married. I want to list all of the patients in alphabetical order, but I want to show only female patient for married couples (ignore the husband).I have a table of patients. Patients may be sin