取出每个组中的单条数据的方法,原理参照上面两篇文章
) D WHERE D.NewIndex = 1
方法2:
方法1:
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY TsServerid ORDER BY TsServerid) NewIndex FROM dbo.T_ts_CardServer) D WHERE D.NewIndex = 1
方法2:
select * from T_ts_CardServer where tscardid in ( select min(tscardid) from T_ts_CardServer group by TsServerid)
效果: