sql random row code example

Example 1: sql pick random row

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

Example 2: t-sql random number for each row

ABS(CHECKSUM(NewId())) % 14