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
)