sql怎么根据总分随机选题

Question

sql怎么根据总分随机选题：比如我要选择10道总分是30的题

Answer 1

ORDER BY RAND()

SELECT * FROM course where '总分'=30 ORDER BY RAND() LIMIT 0,10;