Aggregate Functions Part 1: COUNT() – With examples in MySQL

This Part 1 of a planned 3 blog posts, aims to cover basic usage of common MySQL aggregate functions. COUNT(*) and COUNT(some_expression) are slightly different variations of the same function and we will discover their differences.

(more…)

Advertisements

Use PostgreSQL Aggregate functions for inventory and asset tracking needs.

PostgreSQL’s Aggregate functions can be used to solve and answer many common questions and problems, allowing us to present our data in meaningful ways. Today we will look at an example of how to use some of these powerful functions for inventory or asset tracking needs.

(more…)