How to randomly select rows in SQL?

sql database random

SELECT TOP 5 Id, Name FROM customerNamesORDER BY NEWID()

That said, everybody seems to come to this page for the more general answer to your question:

Selecting a random row in SQL

SELECT column FROM tableORDER BY RAND()LIMIT 1

SELECT column FROM tableORDER BY RANDOM()LIMIT 1

SELECT TOP 1 column FROM tableORDER BY NEWID()

SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY

SELECT column FROM( SELECT column FROM tableORDER BY dbms_random.value )WHERE rownum = 1

SELECT column FROM table ORDER BY RANDOM() LIMIT 1

sql database random

SELECT TOP 5 Id, Name FROM customerNames ORDER BY NEWID()

sql database random

In case someone wants a PostgreSQL solution:

select id, namefrom customerorder by random()limit 5;