random questions from sql server

Question

AVADHESH PATEL · Answer

Hi Loos!SELECT question_idFROM questions ORDER BY NEWID()gives you all the question ids in random order. store the list, and work your way down.There isn't a way to ensure the longest time between repeats without storing the order. You could make it another column on the same table...EDIT: a variation on Mr Jacques' idea:how about a column named random? Shuffle the order like so:update questions set random = ( SELECT question_id FROM questions ORDER BY NEWID())then get each new question like this:select * where random = 'prev_question_id';Then you could shuffle the order at intervals, every night maybe.

forum

random questions from sql server

Can you answer this question?

1 Answers