5,889
社区成员
发帖
与我相关
我的任务
分享
SET V_STMT='
INSERT INTO PERSON_COUNT_INFO(
SELECT TIME,
CITY_ID ,
COUNT(DISTINCT PERSON_ID) AS PERSON_COUNT,
FROM PERSON_INFO A
WHERE A.TIME=INTEGER(';
SET V_STMT=V_STMT||''';
SET V_STMT=V_STMT||VI_YM;
SET V_STMT=V_STMT||''';
SET V_STMT=V_STMT||') GROUP BY TIME,CITY_ID
)
WITH UR ';