How to select N random records from a SQLite table

by

Posted on by

If you want to select N random records from a SQLite table, you need to change the clause as follows:

select * from tableName order by RANDOM() limit N

For example, to select 5 random customers in the customers table, you use the following query:

select * from customers order by RANDOM() limit 5

Some SQLite tools you can try: https://www.withdata.com/sqlite/