Select

Emp

EMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO
7839KINGPRESIDENT - 17-NOV-815000 - 10
7698BLAKEMANAGER783913-MAY-81300020030
7782CLARKMANAGER783909-JUN-813000 - 10
7566JONESMANAGER783902-APR-813000 - 20
7788SCOTTANALYST756609-DEC-823000 - 20
7902FORDANALYST756603-DEC-813000 - 20
7369SMITHCLERK790217-DEC-803000 - 20
7499ALLENSALESMAN769820-FEB-81160030030
7521WARDSALESMAN769822-FEB-81130050030
7654MARTINSALESMAN769828-SEP-812000140030
1 - 10Next

DEPT

DEPTNODNAMELOC
10ACCOUNTINGNEW YORK
20RESEARCHDALLAS
30SALESCHICAGO
1 - 3

JOBS

JOB
ANALYST
CLERK
SALESMAN
MANAGER
PRESIDENT
1 - 5
release 1.0