How to show Questions randomly so that no two student get the same questions in online examination system project in Java Server Pages
Either you can make 3 different tables consisting of different questions. Set the values 1, 2, 3 for 3 tables and find random so that students will get different table of questions. Accordingly, the questions will get displayed.
or if you want to display the questions from a single table, then use the following query:
SELECT * FROM test ORDER BY RAND() LIMIT 1;
The above query display the question randomly.
Hope that it helps!