我想查询所有的普通值 但不是依据所有的列来分组 怎么弄
------解决思路----------------------
SELECT website,COUNT(*) FROM [station].[dbo].Psgr_Info GROUP BY website
------解决思路----------------------
既然用了分组，website 之外的字段只能用统计函数，不能再有什么“普通值”。
------解决思路----------------------
分组了，你显示的列表问题。
------解决思路----------------------
select *
from
(
select *,row_number() over(partition by website order by id) as rn,count(*) over(partition by website) as 汇总
from table1
)t
where rn = 1
------解决思路----------------------
既然使用group by 进行分组，就不能查询全部
select website,sum(website) from tabname group by website
------解决思路----------------------
你是想按照那个字段，取出一条来是吗,可以试试这个：
select *
from
(
select *,
row_number() over(partition by website order by @@spid) rownum
from station.dbo.psgr_info
)t
where rownum = 1