select_group_by.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 10 行

/*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