MySQL 查询日期范围

Question

我用谷歌搜索但没有找到任何相关内容。我有一个像这样的 MySQL 表:

+++++++++++++++++++++++++++++++| roomID |    date    | price |+++++++++++++++++++++++++++++++|  1     | 2012-10-10 |   10  ||  1     | 2012-10-11 |   10  ||  1     | 2012-10-12 |   10  ||  1     | 2012-10-13 |   12  ||  2     | 2012-10-10 |   15  ||  2     | 2012-10-11 |   15  ||  2     | 2012-10-12 |   15  ||  2     | 2012-10-13 |   16  ||  2     | 2012-10-14 |   16  ||  2     | 2012-10-15 |   16  |+++++++++++++++++++++++++++++++

我需要根据价格和房间 ID 获取时间段:

++++++++++++++++++++++++++++++++++++++++++++| roomID |    from    |    till    | price |++++++++++++++++++++++++++++++++++++++++++++|    1   | 2012-10-10 | 2012-10-12 |   10  ||    1   | 2012-10-13 | 2012-10-13 |   12  ||    2   | 2012-10-10 | 2012-10-12 |   15  ||    2   | 2012-10-13 | 2012-10-15 |   16  |++++++++++++++++++++++++++++++++++++++++++++

谢谢!

Answer 1

select roomid,
       min(date) as from,
       max(date) as till,
       price
from periods
group by price
order by price