2014 09 06 sql grouping data by time interval

grouping-data-by-time-interval

• 方法1

http://stackoverflow.com/questions/14781069/grouping-data-by-time-interval

• 方法2

https://community.oracle.com/thread/1042863?tstart=0