random number sql code example

Example 1: sql random integer

SELECT RAND();

Example 2: tsql random number

SELECT FLOOR(RAND()*(b-a+1))+a;

Example 3: select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1