Random Function The Random() function returns random integer it uses Int64 and takes zero (0) argument. The syntax for random function is RANDOM(). SELECT RANDOM() /* returns numbers */ ; It can be used for password protection or to generate data.