[求助]如何写一句SQL，能查询联合语句结果中前10条的数据？

[readings]

比如现在有一个UNION语句：

Select Title AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other
Where [Other_Title] Like '%河北%'
UNION
Select s_name AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi
Where [s_name] Like '%河北%'
Order By [Title] DESC

如何只查询结果中的前10条语句？

[晓风残月0110]

select top 10 from (
Select   Title   AS   [Title]   From   OPENDATASOURCE   ('SQLOLEDB','Data   Source=(local);User   ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other 
  Where   [Other_Title]   Like   '%河北%' 
  UNION   
Select   s_name     AS   [Title]   From   OPENDATASOURCE   ('SQLOLEDB','Data   Source=(local);User   ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi 
  Where   [s_name]   Like   '%河北%' 
  Order   By   [Title]   DESC 
) t

[晓风残月0110]

select top 10 * from (
Select Title AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other 
Where [Other_Title] Like '%河北%' 
UNION 
Select s_name AS [Title] From OPENDATASOURCE ('SQLOLEDB','Data Source=(local);User ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi 
Where [s_name] Like '%河北%' 
Order By [Title] DESC 
) t

[dobear_0922]

select top 10 * 
from
(
Select   Title   AS   [Title]   From   OPENDATASOURCE   ('SQLOLEDB','Data   Source=(local);User   ID=xxxxx;Password=xxxxx').Folkw_MinZuchannel.dbo.MinZu_Other 
  Where   [Other_Title]   Like   '%河北%' 
  UNION   
Select   s_name     AS   [Title]   From   OPENDATASOURCE   ('SQLOLEDB','Data   Source=(local);User   ID=xxxxx;Password=xxxxxx').feiyi.dbo.s_feiyi 
  Where   [s_name]   Like   '%河北%' 
  Order   By   [Title]   DESC 
) T   Order   By   [Title]   DESC

[readings]

楼上各位，是不是哪里出错了？

错误信息如下：
服务器: 消息 1033，级别 15，状态 1，行 8
除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。

[gagaxiaoyuer]

select top 10 from (condition)