如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中。
错误的写法:select distinct top 100 userphone from message order by proxyid desc
正确的写法:select distinct top 100 userphone,proxyid from message order by proxyid desc
如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中。
错误的写法:select distinct top 100 userphone from message order by proxyid desc
正确的写法:select distinct top 100 userphone,proxyid from message order by proxyid desc
转载于:https://www.cnblogs.com/candyzhmm/p/4362999.html