The best replacement for having clause is where clause.

The best alternatives to having clause are rated as following:

★★★★★	where clause
★	where
	group by clause

Your alternative for having clause is not listed? Suggest!

Speaking about having clause, one probably shouldn't forget about group by in sql server.

Other search terms related to having clause and their ratings are:

★★★★★	group by in sql server
★★★★★	subquery
★★★★★	where
★★★	group by oracle
★	aggregate
★	aggregate function

You have in mind a companion for having clause and it is not yet here? Propose!

Google Trends

Scale is based on the average worldwide traffic of having clause in all years. Click on graph for more.

having clause

where clause

where