The best replacement for aggregate function is group by clause.

The best alternatives to aggregate function are rated as following:

★★★★★	group by clause
★★★	scalar function
★	rollup aggregate function

Your alternative for aggregate function is not listed? Suggest!

Speaking about aggregate function, one probably shouldn't forget about group by clause.

Other search terms related to aggregate function and their ratings are:

★★★★★	group by clause
★★★	group by
★★★	subquery
★★★	having clause
★★	group by in sql
★	group by in oracle
★	distinct

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

Google Trends

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

aggregate function

group by clause

scalar function