PostgreSQL›Numeric Functions›RANDOM
←LOG

RANDOMNumeric Functions

SIGN→

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

Syntax

RANDOM()

Example

Enter values below to update the example in real time.

product_name→
products→
-- 무작위 상품 추천 5건
SELECT product_name
FROM products
ORDER BY RANDOM()
LIMIT 5;