Add Having clause

[fdncred]

Sometimes I need the ability to find duplicates in a CSV file. RBQL would be great for this if it supported the having clause.

Here's my example usage.
select a2, count(*) group by a2 where NR > 1 having count(*) > 1

BTW - RBQL is a great helper. Thanks for it!
I forgot to mention that I'm using Rainbow CSV in vscode.

[mechatroner]

Thanks for the feedback!
And thank you for the proposal, I guess it would be possible to implement HAVING, but I haven't look deep into this yet.
BTW you can emulate HAVING with two consecutive queries: first GROUP BY, and then WHERE on the result set of GROUP BY, although this is not an elegant solution.

[fdncred]

Thanks @mechatroner for the tip. Would you mind showing me an example of how to have two consecutive queries like you're suggesting?

[fdncred]

oh, wait. You may mean just get the results of the first query and then run another query on those results. I thought you were saying to do it with one rbql statement.