SHARE
Facebook X Pinterest WhatsApp

NewbieNetwork: Using Aggregate Functions and Operators in PostgreSQL

Jul 20, 2010
ServerWatch content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More



“In Part 1 of this series, I will cover how to use the five most common and basic aggregate functions on PostgreSQL. Those functions are count(), min(),
max(), avg(), and sum(). Look for more fun with aggregates and operators later in this series of articles.”

An aggregate function is a function such as count() or sum() that you can use to calculate totals. In writing expressions and in programming, you can use
SQL aggregate functions to determine various statistics and values. Aggregate functions can greatly reduce the amount of coding that you need to do in
order to get information from your database.

An aggregate function is a function such as count() or sum() that you can use to calculate totals. In writing expressions and in programming, you can use
SQL aggregate functions to determine various statistics and values. Aggregate functions can greatly reduce the amount of coding that you need to do in
order to get information from your database.

Recommended for you...

What Is a Container? Understanding Containerization
What Is a Print Server? | How It Works and What It Does
Nisar Ahmad
Dec 8, 2023
What Is a Network Policy Server (NPS)? | Essential Guide
Virtual Servers vs. Physical Servers: Comparison and Use Cases
Ray Fernandez
Nov 14, 2023
ServerWatch Logo

ServerWatch is a top resource on servers. Explore the latest news, reviews and guides for server administrators now.

Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.