34,571
社区成员
发帖
与我相关
我的任务
分享
--第一个问题的数据
--创建视图ABC
Create View ABC
as
SELECT TOP 100 PERCENT * FROM (
Select 1 id,'A' col
Union All
Select 2 id,'B' col
Union ALL
Select 3 id,'C' col
Union All
Select 4 id,'D' col
Union All
Select 5 id,'E' col
)A ORDER BY ID DESC
GO
--视图中按ID倒排序了,可直接查询视图ABC时,排序失效
SELECT * FROM ABC
GO
--删除视图ABC
Drop View ABC
GO
--第二个问题
--第一个子查询中指定了id倒排,可最后的查询结果中倒排失效,
--order by 只有写在最外层才可以的,如果里面的结果想排序怎么办。
SELECT * FROM
(
SELECT TOP 100 PERCENT * FROM
(Select 1 id,'一' col
Union All
Select 2 id,'二' col
Union ALL
Select 3 id,'三' col
) A ORDER BY id desc
Union All
SELECT TOP 100 PERCENT * FROM
(
Select 4 id,'B' col
Union ALL
Select 5 id,'C' col
Union All
Select 6 id,'D' col
Union All
Select 7 id,'E' col
)B
) AA
GO