SELECT country FROM Hovercraft.Orders GROUP BY country ORDER BY ASC
order by子句中没有给出列名.这可能吗? SSMS说没有.
约尔格
SELECT country FROM Hovercraft.Orders GROUP BY country ORDER BY 1 ASC
– 所以这将按第一列输出(即国家)的内容排序.