The result of the following SELECT statement has as many rows as there are employees in department D01:
SELECT EMPNO, LASTNAME, YEAR(CURRENT DATE - BIRTHDATE) FROM EMPLOYEE WHERE WORKDEPT = 'D01'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.