在找分组后最大一组的值时，如何将临时表换成子查询？
/*

create table Days
(
DayId int identity(1, 1) primary key,
DayCount int,
DayWeek int
)

insert Days(DayCount, DayWeek)
select 1, 1 union all
select 2, 1 union all
select 3, 1 union all
select 4, 1 union all
select 5, 1 union all
select 6, 1 union all
select 7, 1 union all
select 8, 1 union all
select 9, 1 union all
select 10, 1 union all
select 11, 1 union all
select 12, 1 union all
select 13, 2 union all
select 14, 2 union all
select 14, 3 union all
select 14, 3 union all
select 14, 3 union all
select 14, 4 union all
select 14, 4 union all
select 14, 4

*/

select DayWeek, sum(DayCount) as DayCount into #temp from Days where DayWeek > 1 group by DayWeek

select * from #temp

/*

DayWeekDayCount
227
342
442

*/

select top 1 * from
(select a.DayWeek, a.DayCount from #temp a inner join
(select max(DayCount) as DayCount from #temp) b on a.DayCount = b.DayCount) aa order by aa.DayWeek

/*

DayWeekDayCount
342

*/


/*

drop table Days

*/

[解决办法]
用第二句的
[解决办法]
select top 1 DayWeek,DayCount as DayCount from
(
select top 100 percent DayWeek, sum(DayCount) as DayCount from Days where DayWeek > 1 group by DayWeek order by DayCount desc
)a