count

SELECT CONCAT(CLDR_YY, CLDR_MM) AS "월별", COUNT(*) AS "영업일" FROM ( SELECT DISTINCT CLDR_YY, CLDR_MM, CLDR_DD, CLDR_DATE, CLDR_WEEK FROM ATN_CALENDAR WHERE HLDY_YN !='Y' -- 영업일 AND CLDR_YY ='2022' )X GROUP BY CONCAT(CLDR_YY, CLDR_MM)

SELECT '신청: '||TOTAL||'건(전체), '||P_TYPE||'건(PC), '||M_TYPE||'건(모바일)' AS EVENT_MFROM(SELECT COUNT (1) AS TOTAL, COUNT (DECODE (TYPE, 'P', 'P')) AS P_TYPE, COUNT (DECODE (TYPE, 'M', 'M')) AS M_TYPE FROM N_BOARD_EVENT)

-- 테이블 카운트select count(*) from information_schema.tables -- 테이블 row수 카운트select TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,TABLE_TYPE from information_schema.tables