The best replacement for having is where.

The best alternatives to having are rated as following:
★★★★★  where
★★★★  being
★★★  where clause
★★  haven
★★  group by
★★  having had
★  where mysql
★  where sql server
★  getting
★  where sql
  group by sql
  being fromm
  sql where

Your alternative for having is not listed? Suggest!
Speaking about having, one probably shouldn't forget about group by.

Other search terms related to having and their ratings are:

★★★★★ group by
★★ count in sql
★★ your
group by in mysql
group by oracle
group by sql
group by in oracle
group by in sql
group by clause
You have in mind a companion for having and it is not yet here? Propose!

Google Trends

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