binary_float

binary_float_nan1

Objective:

SELECT JOB, DEPTNO, COUNT(*) FROM emp WHERE TO_BINARY_FLOAT(COMM) != BINARY_FLOAT_NAN GROUP BY JOB, DEPTNO

EMP table :Oracle

There are four salesman listed in this table where corresponding data query against the column comm was relevant.