IBM Sterling B2B: Queries for Archive: Difference between revisions
(Criou a página com " = Ver também = * IBM Sterling B2B: SELECT a Code List * IBM Sterling B2B: SELECT Queue, Lifespan, PersistentLevel of Business Process * IBM Sterling| Artigos so...") |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT ARCHIVE_FLAG, count(1) as CNT FROM ARCHIVE_INFO GROUP BY ARCHIVE_FLAG ORDER BY ARCHIVE_FLAG | |||
result: | |||
{| class="wikitable" | |||
|- | |||
! ARCHIVE_FLAG !! CNT | |||
|- | |||
| -1 || 310 | |||
|- | |||
| 0 || 83910 | |||
|- | |||
| 1 || 912571 | |||
|- | |||
| 2 || 4198 | |||
|} | |||
= Ver também = | = Ver também = | ||
Revision as of 10:26, 17 April 2021
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 |