Column name
Jump to navigation
Jump to search
How can I display a column name for an aggregate function?
schema:gisq
Where one of the results returned is calculated (for example with an aggregate) the column name may be assigned arbitrarily.
You should be able to specify a column name.
SELECT region, SUM(population) AS x
FROM bbc
GROUP BY region