取得本周截止到当前为止，所有用户的签到次数

获得本周截止到当前为止，所有用户的签到次数

select t.usermobile,       themeId,       to_char(trunc(sysdate, 'iw'), 'yyyy-mm-dd') begintime,       to_char(trunc(sysdate, 'iw') + 6, 'yyyy-mm-dd') endtime,       count(distinct t.attenddate) countOfAttendance  from user_attendance t where attenddate >= to_char(trunc(sysdate, 'iw'), 'yyyy-mm-dd')   and attenddate <= to_char(sysdate, 'yyyy-mm-dd') group by usermobile, themeid;

表结构
create table USER_ATTENDANCE
(
  ID         NUMBER(9) not null,
  USERMOBILE VARCHAR2(15) not null,
  THEMEID    NUMBER(9),
  ATTENDDATE VARCHAR2(19) not null
)

查看更多 下一篇