MSSQLNumeric FunctionsRAND
LOG10

RANDNumeric Functions

SIGN

Returns a random floating-point value between 0 and 1.

Syntax

RAND([seed])

Example

Enter values below to update the example in real time.

product_name
products
SELECT TOP 5 product_name
FROM products
ORDER BY NEWID();  -- RAND() 대신 NEWID() 권장