「sum」の検索結果 45 件

テクニカルメモ

... ESTDATE,MONTH,12,1) EQ 1 THEN DOLLARS ELSE 0; END TABLE FILE GGSALES SUM TOUGETSU AS '当月' ZENNEN AS '前年同月' BY CATEGORY BY MONTH AS ...

テクニカルメモ

... COUNTRY SEATS SALES ON TABLE HOLD AS HLD1 END -RUN TABLE FILE HLD1 SUM SALES BY COUNTRY ACROSS SEATS END 対応例① HOLDを作成する際に集計 ...

テクニカルメモ

... 得られる結果イメージ: 11/28/2022 14:30:56 TABLE FILE EMP 11/28/2022 14:30:56 SUM SAL 11/28/2022 14:30:56 BY ENAME 11/28/2022 14:30:56 ON TABLE HOLD ...

テクニカルメモ

... さい。 サンプル -SET &LIMIT=10; -DEFAULTH COUNT=0 TABLE FILE CAR SUM CNT.COUNTRY AS COUNT WHERE SALES GE 1000 ON TABLE SET ASNAMES ON ON ...

テクニカルメモ

... = ON SET PAGE-NUM = NOLEAD FILEDEF HLD1 DISK hld.csv TABLE FILE CAR SUM DEALER_COST AS 'COST' COMPUTE CATEGORY/A20V = 'DEALER_COST'; BY COU ...