SUMSEN

摘要： SELECT MAX(today) f_day, min(today) l_day FROM (select today, row_number() over(order by today desc) rn from XXX where today between to_char(sysdate - 30, 'yyyy-mm-dd') and to_char(sysdate - 1, 'yyyy-mm-dd') group by today having(count(*)) > 5)) where r... 阅读全文