This example is based the following regrtbl data. Nulls are indicated by the QUESTION MARK character.
| c1 | height | weight |
|---|---|---|
| 1 | 60 | 84 |
| 2 | 62 | 95 |
| 3 | 64 | 140 |
| 4 | 66 | 155 |
| 5 | 68 | 119 |
| 6 | 70 | 175 |
| 7 | 72 | 145 |
| 8 | 74 | 197 |
| 9 | 76 | 150 |
| 10 | 76 | ? |
| 11 | ? | 150 |
| 12 | ? | ? |
The following SELECT statement returns the number of rows in regrtbl where neither height nor weight is null.
SELECT REG_COUNT(weight,height) FROM regrtbl;
Here is the result:
Regr_Count(weight,height) ------------------------- 9