This page provides answers for the SQL Problem sets.
| SQL Exercise Set #3 | ||
| 1. Create an index on the EMP table which does not allow duplicate employee numbers. | CREATE UNIQUE INDEX empid ON emp (empNo) | |
| 2. Create an autonumber field in the EMP table. | alter table emp
add column empAutoNumber counter (1,1) constraint pkEmp PRIMARY KEY |
|
| SQL Problem Sets |