Sql语句问题!
select top 6 *
from (select BlogID,Hits=max(Hits) from Blog_Article group by BlogID) b
order by b.Hits desc

以上Sql语句查询正确，但是我想

select BlogID,Hits=max(Hits) from Blog_Article group by BlogID

这里查询的时候多返回一个Title字段，但是又不能让他参与group by，该怎么办?

[解决办法]
那在title前也加一个max试试
[解决办法]
--如果你的BlogID只一Title，那可以
select BlogID,Hits=max(Hits), Title from Blog_Article group by BlogID, Title

--如果你的BlogID多Title，查的候，你希望取哪Title，如果是便取一，可以
select BlogID,Hits=max(Hits), Title = max(Title) from Blog_Article group by BlogID
--或者
select BlogID,Hits=max(Hits), Title = min(Title) from Blog_Article group by BlogID
[解决办法]
另外，你的句可以做下化

select top 6 *
from (select BlogID,Hits=max(Hits) from Blog_Article group by BlogID) b
order by b.Hits desc
改
select top 6 BlogID,Hits=max(Hits) from Blog_Article group by BlogID
order by Hits desc