今天遇到一個問題，如何從題庫中亂數挑選不重複的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()
文章標籤
全站熱搜
留言列表
