function_count.sql

AbsDataBase5.16 最新版

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of COUNT function.
  This query counts number of rows in the table "Employee". Having performed it, you will have one column named "c" and one row in it containing number of rows in the table.*/

select (count (*)) as "c"
  from "employee" e1