- /*
- SELECT EMPNO,COMM FROM EMP WHERE COMM IS NULL;
- SELECT EMPNO,COMM FROM EMP WHERE COMM = NULL;
-
- SQL> SELECT EMPNO,COMM FROM EMP WHERE COMM IS NULL;
-
- EMPNO COMM
-
- 7369
- 7566
- 7698
- 7782
- 7788
- 7839
- 7876
- 7900
- 7902
- 7934
-
- 10 rows selected
-
-
- SQL> SELECT EMPNO,COMM FROM EMP WHERE COMM = NULL;
-
- EMPNO COMM
-
-
-
|