Incorrect frequency query
I'm running a simple frequency query to determine the number of records that fall into each unique status value. The record counts do not add up to the total number of records in the table. The queries I am running and the results they produce are below.
| SELECT |
| COUNT(*) AS REC_CNT |
| FROM |
| STAT.STATUS; |
|
SELECT |
||
| STATUS, | ||
| COUNT(*) AS REC_CNT | ||
| FROM | ||
| STAT.STATUS | ||
| GROUP BY | ||
| STATUS | ||
|
ORDER BY 1;
|
| STATUS | REC_CNT |
| 1 | 419,971 |
| 2 | 1,215,599 |
| 3 | 343 |
| 8,258,409 | |
| Total | 9,894,322 |
As you can see after adding the STATUS group by 183 records are missing. Any ideas?
0