建表查询5月份连续登录5天的用户
建表查询5月份连续登录5天的用户CREATE TABLE USER_LOGON_INFO(USER_ID VARCHAR2(10),LOG_TS VARCHAR2(20));INSERT INTO USER_LOGON_INFO (USER_ID, LOG_TS)VALUES (‘A0001’, ‘2020-05-08’);INSERT INTO USER_LOGON_INFO (USER_ID, LOG_TS)VALUES (‘A0001’, ‘2020-05-06’);INSERT
原创
2020-09-01 21:02:35 ·
358 阅读 ·
0 评论