Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : SELECT : GROUP BY clause : Grouping by alias
Grouping by alias
The GROUP BY clause orders the result set according to an alias specified in the SELECT statement.


GROUP BY [alias]...


In this instance, the alias may be used as a simple column reference to a database table, or an actual expression composed of arithmetic expressions, character operators, date operators, or scalar functions. The alias is essentially an alternate name.


In the following example, the GROUP BY clause refers to the "CityState" phrase of the SELECT statement:
SELECT CONCAT (State, City) AS "CityState",
       COUNT (city)
  FROM Pub.Customer
  GROUP BY "CityState";