Group Query Results By Last Name. This simple report groups records from the Orders table in Northwind the sample database that comes with Access. SELECT id first_name last_name FROM customer ORDER BY last_name DESC.
When there isnt a GROUP BY clause it is generally understood the aggregate function applies to all filtered results. Group function is not allowed here. Above query will say ORA-00934.
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.
The results will be sorted ascending by the LAST_NAME column only. Summarize data by group with a select query in Access by Mary Richardson in Software on June 24 2005 1200 AM PST You can use a select query to summarize the data in your Access table by group. Now run the query again and you will see the following results. The GROUP BY clause.