--天 select (select top 1 jiage from tb where convert(varchar(10),shijian,120) = convert(varchar(10),t.shijian,120) order by shijian) as firstvalues, (select top 1 jiage from tb where convert(varchar(10),shijian,120) = convert(varchar(10),t.shijian,120) order by shijian desc) as lastvalues, max(jiage) as maxvalues, min(jiage) as minvalues, sum(xianshou) as xianshou from tb t group by convert(varchar(10),shijian,120)
select
(select top 1 jiage from tb
where convert(varchar(10),shijian,120) = convert(varchar(10),t.shijian,120)
order by shijian) as firstvalues,
(select top 1 jiage from tb
where convert(varchar(10),shijian,120) = convert(varchar(10),t.shijian,120)
order by shijian desc) as lastvalues,
max(jiage) as maxvalues,
min(jiage) as minvalues,
sum(xianshou) as xianshou
from tb t
group by convert(varchar(10),shijian,120)