Read the article to learn more about the aggregate function alias in PostgreSQL. As part of our PostgreSQL Support, Bobcares provides answers to all of your questions.

Aggregate Function Alias in PostgreSQL

In PostgreSQL, assigning a name or label to an aggregate function result in a query is known as an aggregate function alias. This is especially helpful when the query’s output has to reference or display the aggregate function’s result.
The following explains how to use aliases in Postgres:

1. In the SELECT clause of a query, the AS keyword can be used to assign an alias to the output of a function. The following is the code:

Here, total_records is the alias assigned to the result of the COUNT(*) aggregate function, thus, representing the total number of records in the table.

2. Without using the AS keyword, an alias can also be used straight in the SELECT clause. Column aliases can be specified in Postgres without the need for AS:

Here, total_records is the alias assigned to the result of the COUNT(*) function.

3. When performing calculations on grouped data, aggregate functions and the GROUP BY clause are often used. For clarity in certain cases, we can give the aggregated columns aliases:

Here, avg_salary is the alias assigned to the result of the AVG(salary) function, also showing the average salary for each department.

4. We can use an alias to refer to the output of an aggregate function later on in the query, for example, in the ORDER BY clause or in calculations that follow.

[Looking for a solution to another query? We are just a click away.]

Conclusion

In PostgreSQL, we can provide an alias for an aggregate function explained above in this article by our Experts.