萌新求助

[Secends_]

开始是这样的

想得到这样的结果

[bandover]

select distinct A,B,C,D,E,F,G from table

[中国风]

SELECT *
FROM
(SELECT *
      , ROW_NUMBER() OVER (PARTITION BY B, C, D, F, G ORDER BY A) AS RN
 FROM table1) AS T
WHERE RN=1;

[Secends_]

不对的，实现不了