1> CREATE TABLE employee (emp_no INTEGER NOT NULL,
2> emp_fname CHAR(20) NOT NULL,
3> emp_lname CHAR(20) NOT NULL,
4> dept_no CHAR(4) NULL)
5>
6> insert into employee values(1, "Matthew", "Smith", "d3")
7> insert into employee values(2, "Ann", "Jones", "d3")
8> insert into employee values(3, "John", "Barrimore","d1")
9> insert into employee values(4, "James", "James", "d2")
10> insert into employee values(5, "Elsa", "Bertoni", "d2")
11> insert into employee values(6, "Elke", "Hansel", "d2")
12> insert into employee values(7, "Sybill", "Moser", "d1")
13>
14> select * from employee
15> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
emp_no emp_fname emp_lname dept_no
----------- -------------------- -------------------- -------
1 Matthew Smith d3
2 Ann Jones d3
3 John Barrimore d1
4 James James d2
5 Elsa Bertoni d2
6 Elke Hansel d2
7 Sybill Moser d1
(7 rows affected)
1> -- Write a query as part of the FROM clause
2>
3> SELECT emp_fname, emp_lname
4> FROM (SELECT * FROM employee WHERE emp_no >= 1) AS empno_10000
5> GO
emp_fname emp_lname
-------------------- --------------------
Matthew Smith
Ann Jones
John Barrimore
James James
Elsa Bertoni
Elke Hansel
Sybill Moser
(7 rows affected)
1>
2> drop table employee
3> GO