Example

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'