FROM EMP EMP1, EMP
SELECT EMP1.EMP_NO, EMP2.EMP_NO
FROM EMP EMP1, EMP EMP2
WHERE EMP1.EMP_NO <> EMP2.EMP_NO
AND NOT ((EMP1.EMP_NAME, EMP1.EMP_BDATE) DISTINCT FROM
(EMP2.EMP_NAME, EMP2.EMP_BDATE));
Введение в модель данных SQL
SELECT EMP1.EMP_NO, EMP2.EMP_NO
FROM EMP EMP1, EMP EMP2
WHERE EMP1.EMP_NO <> EMP2.EMP_NO
AND NOT ((EMP1.EMP_NAME, EMP1.EMP_BDATE) DISTINCT FROM
(EMP2.EMP_NAME, EMP2.EMP_BDATE));