Home Software Scripts Notes/Articles Online Toolbox Gallery

Computing
GNU/Linux
Microsoft
BSD/Unix
C#/.NET
C/C++
PHP
SQL

MS Access Connection Strings MSSQL Case Sensitivity MySQL Root Password Reset MySQL Check Slow Queries Column Counting Quick Note on CROSS JOIN Quick Note on INNER JOIN Random Rows

HTML
JavaScript
Java
CSS
Electrical

SQL Random Rows

By 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()