夜市小霸王

今天遇到一個問題，如何從題庫中亂數挑選不重複的n個題目

原本想說在中介端再處理，但是覺得麻煩，查一下google，有找到資訊

---

SELECT TOP 3 a.no AS 題目編號,a.question ,a.content,a.answer
FROM dbo.question as a INNER JOIN
(SELECT max(no) as no
FROM dbo.question group by no) as b ON a.no = b.no
WHERE (a.qclass='A02') 
ORDER BY NEWID()

---