摘要： select * from ( select *,ROW_NUMBER() over (PARTITION BY f1 ORDER BY f1) as r from [Agriculture].[dbo].[cc] ) a where a.r=1 select COUNT(distinct quer 阅读全文