tsql random code example

Example 1: tsql random number

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

Example 2: select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1