I'm 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. In SQL, this would be something like:
select name, count(1)
from table
group by name
having count(1) = 1.
Is this possible using the query all record function? I don't see it in the output tab.