doing a group by to aggregate a table and get a count of record. I'd like to only get the rows where the count = 1 select name, count(1) from table group by name having count(1) = 1
