LibreOffice Base SQL: Aggregation, Data Herding

Today, I will continue the discussion of SQL queries with queries that involve different ways to group or derive new data based on the data in a table. The SQL in this post is based on the TeamMembers database. For instructions on setting up the database in LibreOffice and a short description of the database and tables, see the post at

Herding the Data in Tables

The word aggregation comes from the Latin with a literal meaning of “to herd.” So, an aggregation is a collection or gathering of things together. In this post I will show you how to herd some of the data in your tables. I will also show you how to get new data derived from the data in a table. Continue reading


LibreOffice Base SQL: Table Constraints

Constraints specify rules for the data in a table’s fields. We have already discussed two of the constraints, NOT NULL and DEFAULT. In this post we will look at four more, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK. Continue reading

LibreOffice Base SQL: Altering Tables

So far, we have looked at the different data types and creating tables using SQL in LibreOffice Base with the default HSQLDB database management system. Sometimes when you create a table using SQL, you don’t always get it right the first time, so SQL allows you to alter, or change, the structure and layout of the table. Continue reading