Selecting rows that have no data

To select only rows that have no data, type:

WHERE columnname IS NULL

For example, to select employees with no commission, type:

WHERE COMM IS NULL
[ Previous Page | Next Page | Contents | Index ]