IBM Sterling B2B: Queries for Archive
SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG
result:
| ARCHIVE_FLAG | CNT |
|---|---|
| -1 | 310 |
| 0 | 83910 |
| 1 | 912571 |
| 2 | 4198 |
SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG
result:
| ARCHIVE_FLAG | CNT |
|---|---|
| -1 | 310 |
| 0 | 83910 |
| 1 | 912571 |
| 2 | 4198 |