时间分组，每2个一行
表格如下：
time
9:05
9:10
9:11
9:15
9:19
....
想得到以下结果集
9:05 9:10
9:11 9:15
9:19
或者
9:05 9:10
9:11 9:15
[解决办法]
declare @a table([time] varchar(10))
insert @a select '9:05 '
union all select '9:10 '
union all select '9:11 '
union all select '9:15 '
union all select '9:19 '
select t1,t2 from
(select [time] t1,id from (select [time],id=(select count(1) from @a where [time] <=a.[time]) from @a a) b where id%2=1) a1
left join
(select [time] t2,id from (select [time],id=(select count(1) from @a where [time] <=a.[time]) from @a a ) c where id%2=0) a2
on a1.id=a2.id-1
