select time1,time2,data1=(select top 1 data from [table] where time=a.time1)
data2=(select top 1 data from [table] where time=a.time2) from
(select time1=min(time),time2=max(time) from [table] where time between '04-05-25' and '04-08-26') a
data2=(select top 1 data from [table] where time=a.time2) from
(select time1=min(time),time2=max(time) from [table] where time between '04-05-25' and '04-08-26') a
而且运行有错误,