select_into.sql

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

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of SELECT INTO statement.
  The query returns all names from the field "FirstName" excluding duplicates and places it inside a new table giving it name "NewTable".*/

drop table if exists NewTable;
select distinct e1."FirstName"
  into NewTable
  from "employee" e1