SELECT RANDOM in SQL

If you want to select random rows or generate random values in SQL, different databases have different functions for randomness.

How to select random rows:

1. PostgreSQL

SELECT * FROM table_nameORDER BY RANDOM()LIMIT 1;

2. MySQL

SELECT * FROM table_nameORDER BY RAND()LIMIT 1;

3. SQL Server

SELECT TOP 1 * FROM table_nameORDER BY NEWID();

4. Oracle

SELECT * FROM (  SELECT * FROM table_name  ORDER BY DBMS_RANDOM.VALUE)WHERE ROWNUM = 1;

How to generate a random number:

PostgreSQL

SELECT RANDOM(); -- returns a float between 0 and 1

MySQL

SELECT RAND();

SQL Server

SELECT RAND();

Oracle

SELECT DBMS_RANDOM.VALUE FROM dual;

Example: Get 5 random products (MySQL)

SELECT * FROM productsORDER BY RAND()LIMIT 5;

If you want, I can help with a query to select random rows for your specific SQL database!