效果是DISTINCT CUS_NO,并且同时显示CUS_NAME.
SELECT CUS_NO,MIN(CUS_NAME) AS CUS1 FROM dbo.CUS GROUP BY CUS_NO
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。
SELECT CUS_NO,MIN(CUS_NAME) AS CUS1 FROM dbo.CUS GROUP BY CUS_NO