Question

select * from 表明 order by newid() 随即查询 有什么用？

Answer 1

模拟样本分析用，举一个例子，如果某种产品有许多，我要看一下产品的次品率，当然要随即抽选n个，再看其中有多少个次品，最终求得该种产品的次品率。

Answer 2

SELECT * FROM
(SELECT TOP (8) Chapter, 题号, 题目, A, B, C, D FROM X WHERE (Chapter = '三') ORDER BY NEWID()) AS x
UNION
SELECT * FROM
(SELECT TOP (2) Chapter, 题号, 题目, A, B, C, D FROM X WHERE (Chapter = '六') ORDER BY NEWID()) AS y