OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Statements > CREATE TABLE > CREATE TABLE Examples
Was this helpful?
CREATE TABLE Examples
1. Create the employee table with columns eno, ename, age, job, salary, and dept.
create table employee
  (eno     smallint,
   ename   varchar(20) not null,
   age     integer,
   job     smallint,
   salary  float,
   dept    smallint
   started date);
2. Create a table listing employee numbers for employees who make more than the average salary.
create table highincome as
  select eno
  from employee
  where salary 
   (select avg (salary)
    from employee);
Last modified date: 04/03/2024