News for hackers. Stuff that matters.
Re:Our SQL interview questions by siddboots on Friday May 31, 2013 @06:28AM (#5797733)
I avoid `having` wherever possible these days. There are data analysts in my team that I know would have to think twice about it if they encountered it in my code, and to be honest, it's a bit of an wart in the SQL grammar anyway.

In (almost) all cases, a subquery with an extra `where` clause will have equal performance to a `having` clause in the main query.

See the final example in: http://en.wikipedia.org/wiki/Having_(SQL)

There are no comments on this comment yet.