SQL Random RowsBy Dag, on December 30th, 2016
To retrieve random rows in SQL you can consider the following SQL queries. It's worth to mention that this option suit small needs best, e.g. 50-100 records/rows. This is in regards to performance.
MYSQL: SELECT * FROM Table ORDER BY RAND() LIMIT 0,100
MSSQL: SELECT TOP 100 * FROM Table ORDER BY RAND()