SQL SELECT RANDOM
The SQL SELECT RANDOM() function returns the random row. It can be used in online exam to display the random questions.
There are a lot of ways to select a random record or row from a database table. Each database server needs different SQL syntax.
If you want to select a random row with MY SQL:
If you want to select a random row with Microsoft SQL server:
If you want to select a random record with ORACLE:
If you want to select a random row with PostgreSQL:
Next TopicSQL Select As
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week