I have a range of values that can have an associated gender like 'm', 'f'. I want to include all distinct values that have the same gender across all records. Like if the records are - abc f abc m def m def m def m I'd include "def" but exclude "abc". I need to simulate something like set (followed by count) functionality on a column. Is there a way to do it? Thanks!
