random row sql 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
SELECT column FROM table
ORDER BY RAND()
LIMIT 1
ABS(CHECKSUM(NewId())) % 14