 复制WITH active AS (SELECT 100 UID,高频 2021-04-01dt UNIONALLSELECT 101 UID, 2021-04-01dt UNIONALLSELECT 102 UID, 2021-04-01dt UNIONALLSELECT 103 UID, 2021-04-01dt UNIONALLSELECT 100 UID, 2021-04-02dt UNIONALLSELECT 101 UID, 2021-04-02dt UNIONALLSELECT 102 UID, 2021-04-02dt UNIONALLSELECT 103 UID, 2021-04-02dt UNIONALLSELECT 104 UID, 2021-04-02dt UNIONALLSELECT 100 UID, 2021-04-03dt UNIONALLSELECT 104 UID, 2021-04-03dt UNIONALLSELECT 101 UID, 2021-04-04dt UNIONALLSELECT 102 UID, 2021-04-04dt UNIONALLSELECT 103 UID, 2021-04-04dt UNIONALLSELECT 104 UID, 2021-04-04dt UNIONALLSELECT 105 UID, 2021-04-04dt UNIONALLSELECT 102 UID, 2021-04-03dt) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35. |