在oracle中按连续天数检索记录

SELECT start_date, end_date
FROM your_table
WHERE start_date = (
    SELECT MIN(start_date)
    FROM (
        SELECT start_date, end_date, 
               ROW_NUMBER() OVER (ORDER BY start_date) AS rn
        FROM your_table
        WHERE start_date >= TRUNC(SYSDATE) - 7 -- 检索最近7天的记录
    )
    WHERE rn = 1
)
AND end_date = (
    SELECT MAX(end_date)
    FROM (
        SELECT start_date, end_date, 
               ROW_NUMBER() OVER (ORDER BY start_date) AS rn
        FROM your_table
        WHERE start_date >= TRUNC(SYSDATE) - 7 -- 检索最近7天的记录
    )
    WHERE rn = 1
)