sql random number between 1 and 100 for each row code example

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