求一SQL语句

[WeiWY]

表A 有四列 id,C1,C2,其中ID为主键。
我想把如下两个查询结果合并到一起：
1.select top 10 * from A where C1=0 order by id desc

2.select * from A where C1=1

使用
select top 10 * from A where C1=0 order by id desc union select * from A where C1=1 语法通不过。

[zsl5305256]

select * from
(
select top 10 * from A where C1=0 order by id desc
) a
union select * from A where C1=1

[一者仁心]

select * from A where C1=1
union all
select * from (select top 10 * from A where C1=0 order by id desc) as B
union all
select * from A where C1=1

两种方法

[marco08]

--try


select * from A where C1=1
union
select top 10 * from A where C1=0 order by id desc

[cxmcxm]

同意楼上