|
1>
2> CREATE TABLE employee (emp_no INTEGER NOT NULL,
3> emp_fname CHAR(20) NOT NULL,
4> emp_lname CHAR(20) NOT NULL,
5> dept_no CHAR(4) NULL)
6>
7> insert into employee values(1, 'Matthew', 'Smith', 'd3')
8> insert into employee values(2, 'Ann', 'Jones', 'd3')
9> insert into employee values(3, 'John', 'Barrimore','d1')
10> insert into employee values(4, 'James', 'James', 'd2')
11> insert into employee values(5, 'Elsa', 'Bertoni', 'd2')
12> insert into employee values(6, 'Elke', 'Hansel', 'd2')
13> insert into employee values(7, 'Sybill', 'Moser', 'd1')
14> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1> -- Use of a comparison operator in the WHERE clause.
2>
3> SELECT emp_lname, emp_fname FROM employee WHERE emp_no>= 15000
4> GO
emp_lname emp_fname
-------------------- --------------------
(0 rows affected)
1>
2> drop table employee
3> GO
1>
|