select
min(LOG_DATE)登录时间,
sum(decode(LOG_event,6101,1,0))录入档案,
sum(decode(LOG_event,6102,1,0))修改档案,
max(LOG_DATE)退出时间
where LOG_DATE between to_date(dateStr1,'frmStr') and to_date(dateStr2,'frmStr')
group by SEQ_NO
min(LOG_DATE)登录时间,
sum(decode(LOG_event,6101,1,0))录入档案,
sum(decode(LOG_event,6102,1,0))修改档案,
max(LOG_DATE)退出时间
where LOG_DATE between to_date(dateStr1,'frmStr') and to_date(dateStr2,'frmStr')
group by SEQ_NO
连decode都不支持?
用的不是ORACLE数据库?
jiezhi(西域浪子)是高手,非常感谢,给100分。