Use the ORDER BY clause
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> GO 1> insert into employee values(1, 'Matthew', 'Smith', 'd3') 2> insert into employee values(2, 'Ann', 'Jones', 'd3') 3> insert into employee values(3, 'John', 'Barrimore','d1') 4> insert into employee values(4, 'James', 'James', 'd2') 5> insert into employee values(5, 'Elsa', 'Bertoni', 'd2') 6> insert into employee values(6, 'Elke', 'Hansel', 'd2') 7> insert into employee values(7, 'Sybill', 'Moser', 'd1') 8> GO (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) 1> select * from employee 2> GO 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> -- Use the ORDER BY clause. 2> 3> SELECT emp_no, emp_fname, emp_lname FROM employee ORDER BY emp_no 4> GO emp_no emp_fname emp_lname ----------- -------------------- -------------------- 1 Matthew Smith 2 Ann Jones 3 John Barrimore 4 James James 5 Elsa Bertoni 6 Elke Hansel 7 Sybill Moser (7 rows affected) 1> drop table employee 2> GO 1>