摘要：思路：将日期天数与行号的差值作为分组条件 SELECT DATE, TO_DAYS(DATE)-ROW_NUMBER() OVER () DIFF -- 分组FROM DATE ORDER BY DATE SELECT DIFF,COUNT(*) FROM(SELECT DATE, TO_DAYS( 阅读全文