function_count.sql

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

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