union附近有语法错误？？UNION ALL前后单个执行有没错的

来源：百度知道 编辑：UC知道 时间：2024/06/08 13:58:15
SELECT TOP 26 *
FROM one_select
WHERE (come = 0) AND (grade = 0)
ORDER BY NEWID()
UNION ALL
SELECT TOP 1 *
FROM one_select
WHERE (come = 1) AND (grade = 0)
ORDER BY NEWID()

这样试下，把order by 写在最后，用下面的语句试下：
select a.* from(
SELECT TOP 26 *
FROM one_select
WHERE (come = 0) AND (grade = 0)
UNION ALL
SELECT TOP 1 *
FROM one_select
WHERE (come = 1) AND (grade = 0)
) a
ORDER BY a.NEWID()

用union 查询的东西 类型要一样，