例1:关键字 'ORDER' 附近有语法错误。
(SELECT
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称]
)
union all
(
SELECT
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称])
注:union 将会自动删除重复项,union all 则不会删除。
例2:除非另外还指定了 TOP 或 FOR XML,否则,ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。
select * from (SELECT
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称]
) t1
union all
select * from (SELECT
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称]
) t2
例3:正确
select * from (SELECT top 1000
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称]
) t1
union all
select * from (SELECT top 1000
[分类名称]
,[父类编码]
FROM [WSIPDB].[dbo].[分类列表]
ORDER BY [分类名称]
) t2