select_group_by.sql

Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This example illustrates use of GROUP BY keywords. 
  After performing this query the resulting dataset will contain names of employees and a number - how many times this name is met in the table.*/

select e1."FirstName", count(e1."FirstName") as "cntFirstName"
  from "employee" e1
 group by e1."FirstName"
 order by "cntFirstName" desc