为啥这里边提示order by错误！比较强的大哥们过来看看呗

[haoztao]

SELECT distinct COUNT(CustomerID) AS Num, Country FROM Customers
where country in (select distinct top 3 country from Customers order by DESC)
GROUP BY Country

是不是在union中也不能用order？

[haoztao]

OK
谢谢各位啦，呵呵！只要把那个union说清楚就可以啦！

[子陌红尘]

order by DESC !!!??? 按什么排序啊！？


SELECT distinct COUNT(CustomerID) AS Num, Country FROM Customers
where country in (select distinct top 3 country from Customers order by country DESC)
GROUP BY Country


是不是在union中也不能用order？
在使用UNION联合的多个查询中，只能在UNION联合的多个查询中的最后一个查询中指定排序，其他查询都不允许包含Order by子句。

[zjcxc]

SELECT distinct COUNT(CustomerID) AS Num, Country FROM Customers
where country in (
select distinct top 3 country from Customers order by country DESC) --排序的列名呢?
GROUP BY Country

[hsj20041004]

主要是缺少了排序的列名！！！
和 “在使用UNION联合的多个查询中，只能在UNION联合的多个查询中的最后一个查询中指定排序，其他查询都不允许包含Order by子句。”无关！！。。

[zjcxc]

--在union/union all中使用排序的方式如下:

--对union中的各语句使用order by
select * from(
select top 3 id from sysobjects order by id)a
union --或者union all
select * from(
select top 3 id from sysobjects order by id desc)a


--对最终结果order by
select top 3 id from syscolumns
union --或者union all
select top 3 id from sysobjects
order by id desc