SELECT
CUS_NO,
MIN
(CUS_NAME)
AS
CUS1
FROM
dbo.CUS
GROUP
BY
CUS_NO
效果是DISTINCT CUS_NO,并且同时显示
CUS_NAME.
转载于:https://www.cnblogs.com/alanliu/archive/2008/02/25/1080626.html
转载于:https://www.cnblogs.com/alanliu/archive/2008/02/25/1080626.html