请高人指教,该如何解决

2012-01-09

请高人指教数据表123 a b c123 a b d123 a b c456 e f h456 e f h查询结果123 a b c123 a b d[解决办法]SQ

请高人指教
数据表
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 codeWITH CTE AS(SELECT *,ROW_NUMBER() OVER(PARTITION BY 行号,字段1,字段2,字段3) AS RNFROM 表)SELECT * FROM CTE WHERE RN = 1

热点排行

Bad Request.

SQL Server

请高人指教,该如何解决