Oracle数据库 sql高手请进来:取出某段时间段内,时间中天数连续的...答:直接用查询就可以得到你要的结果:select ID,NAME,VISIT_TIME from ( select ID,NAME,VISIT_TIME ,CNT ,max(CNT) over () MX from ( select ID,NAME,VISIT_TIME ,count(MINDATE) over (partition by MINDATE) CNT from ( select ID,NAME,VISIT_TIME ...