请高人指教
数据表
123 a b c
123 a b d
123 a b c
456 e f h
456 e f h
查询结果
123 a b c
123 a b d

[解决办法]

SQL code

declare @T table (col1 int,col2 varchar(1),col3 varchar(1),col4 varchar(1))insert into @Tselect 123,'a','b','c' union allselect 123,'a','b','d' union allselect 123,'a','b','c' union allselect 456,'e','f','h' union allselect 456,'e','f','h'select TOP 2 * from @T/*col1        col2 col3 col4----------- ---- ---- ----123         a    b    c123         a    b    d*/
[解决办法]
SQL code
WITH CTE AS(SELECT *,ROW_NUMBER() OVER(PARTITION BY 行号,字段1,字段2,字段3) AS RNFROM 表)SELECT * FROM CTE WHERE RN = 1