Generating random numbers in SQL can be done using different functions depending on the SQL database management system (DBMS) you are using. Here are ways to do this in some popular SQL databases:
###### 1. **SQL Server**

You can use the *NEWID()* function along with the *CHECKSUM()* function to generate random integers.
SELECT ABS(CHECKSUM(NEWID())) % 100 AS RandomNumber; -- Generates a random number between 0 and 99

For random floating-point numbers between 0 and 1, you can use:
SELECT CAST(NEWID() AS FLOAT) AS RandomFloat;

###### 2. **MySQL**

In MySQL, you can use the *RAND()* function:
SELECT ROUND(RAND() * 100) AS RandomNumber; -- Generates a random number between 0 and 100

###### 3. **PostgreSQL**

In PostgreSQL, you can use the *RANDOM()* function:
SELECT FLOOR(RANDOM() * 100) AS RandomNumber; -- Generates a random integer between 0 and 99

###### 4. **SQLite**

SQLite also has a *RANDOM()* function:
SELECT ABS(RANDOM()) % 100 AS RandomNumber; -- Generates a random number between 0 and 99

For floating-point numbers between 0 and 1:
SELECT RANDOM() / 9223372036854775807.0 AS RandomFloat; -- Generates a random float between -1 and 1

###### 5. **Oracle**

In Oracle, you can use the *DBMS_RANDOM* package:
SELECT TRUNC(DBMS_RANDOM.VALUE * 100) AS RandomNumber FROM DUAL; -- Generates a random number between 0 and 99

###### Summary

Choose the method suitable for your SQL database system. Ensure to adjust the range and format as needed based on your specific requirements.