Hello Friends,
I am using below query to get the random records but in some cases the questions been repeating.
SELECT top 1 table.* FROM myTable table WHERE table.active = 1 and table.isExclusive = 0 and table.AutoID < @questionID AND table.AnswerType = 0 order by NEWID()
Thanks&Regards
iluvdotnetfunda