一天不管登录多少次,也只算一次? 也就是说一周最多算登录7次? LZ的意思,应该是想问,要查看某个ID,一周内有几天登录了系统。是这样吗?考虑下面这条SQL: select logid,count(1) from ( select logid,trunc(logtime),count(1) from logtable t where t.logtime >= to_date('2013-01-10 00:00:00','yyyy-mm-dd hh24:mi:ss') and t.logtime < to_date('2013-01-17 00:00:00','yyyy-mm-dd hh24:mi:ss') group by logid,trunc(logtime) ) group by logid;
LZ的意思,应该是想问,要查看某个ID,一周内有几天登录了系统。是这样吗?考虑下面这条SQL:
select logid,count(1) from
(
select logid,trunc(logtime),count(1) from logtable t
where t.logtime >= to_date('2013-01-10 00:00:00','yyyy-mm-dd hh24:mi:ss')
and t.logtime < to_date('2013-01-17 00:00:00','yyyy-mm-dd hh24:mi:ss')
group by logid,trunc(logtime)
) group by logid;