发现这个语句是错的啊？？？不能执行
select top 6 * from T_EXAM where type=1 and difficulty=1 and distinguish=1 order by newid()
union all
select top 2 * from T_EXAM where type=2 and difficulty=1 and distinguish=1 order by newid()
union all
select top 5 * from T_EXAM where type=2 and difficulty=2 and distinguish=1 order by newid()
union all
select top 7 * from T_EXAM where type=2 and difficulty=2 and distinguish=2 order by newid()


加了newid()是不行了。


[解决办法]
lz要的结果什么？
这样？

SELECT  *
FROM    ( SELECT TOP 6
                    *
          FROM      T_EXAM
          WHERE     type = 1
                    AND difficulty = 1
                    AND distinguish = 1
          UNION ALL
          SELECT TOP 2
                    *
          FROM      T_EXAM
          WHERE     type = 2
                    AND difficulty = 1
                    AND distinguish = 1
          UNION ALL
          SELECT TOP 5
                    *
          FROM      T_EXAM
          WHERE     type = 2
                    AND difficulty = 2
                    AND distinguish = 1
          UNION ALL
          SELECT TOP 7
                    *
          FROM      T_EXAM
          WHERE     type = 2
                    AND difficulty = 2 
 
                    AND distinguish = 2
        ) T
ORDER BY NEWID()