Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 21.2

COLUMN

GROUP BY Function

How to summarize rows with the same value

Issue: 21.2 (March/April 2023)
Author: Vince Du Beau
Author Bio: Vince is an experienced Filemaker developer. He is exploring Xojo as an alternative to Filemaker.
Article Description: No description available.
Article Length (in bytes): 3,938
Starting Page Number: 70
Article Number: 21209
Resource File(s):

Download Icon project21209.zip Updated: 2023-03-01 10:08:18

Related Link(s): None

Excerpt of article text...

The following definition of GROUP BY is from the w3schools website:

Define our ODBC database

The GROUP BY statement groups rows that have the same values into summary rows, like "find the number of customers in each country".

The GROUP BY statement is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more columns.

...End of Excerpt. Please purchase the magazine to read the full article.