SQL左连接去除重复数据

Question

SELECT
c01,c03,c04,c05,c06,c07,c08,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19
FROM
T_ReportHour A LEFT OUTER JOIN collect B ON A.Report_Hour=B.R_Hour
AND
B.R_Date=@R_Date+1 WHERE
A.Report_Hour>=0 AND
a.Report_Hour<=8 AND
A.ABC>15
END

如图：去除重复一hang10.0值，不影响格式（11行，空出来）

Answer 1

https://www.cnblogs.com/wujb/p/13353651.html