Three random records have been generated from the “emp_data” table. Use the RANDOM() function to get three random records from the selected table: SELECT * For instance, the below snippet shows all rows of the “emp_data” table: SELECT * FROM emp_data In Postgres, the RANDOM() function can be used with the ORDER BY clause to get the random records of a particular table. The below-given code will generate a random integer between 5 and 25: SELECT FLOOR(RANDOM()*(25 - 5 + 1)) + 5 As random_val Ī random integer has been successfully generated between the specified range.Įxample 4: Using RANDOM() Function on Table’s Data The following example demonstrates how to generate a random numeric value between 0(included) and 1(not included) via the RANDOM() function: SELECT RANDOM() AS random_number Ī random number between the range “0=5” and “num <15”: SELECT RANDOM()*(15 - 5) + 5 Ī random numeric value has been generated between the given range, i.e., “5<= num < 15”.Įxample 3: Generating a Random Integer Between a Specific Range The above-given syntax will generate a random integer between Num_1 and Num_2, inclusive. However, the functions like FLOOR() and TRUNC() can be used with the RANDOM() function to get a random integer. The return type of the RANDOM() function is DOUBLE PRECISION. Where “Num_1” is the least value and “Num_2” represents the greatest value. Use the below-provided syntax to get a random number between a specific range: SELECT RANDOM()*(Num_2- Num_1) + Num_1 The below-provided syntax is used in Postgres to get a random number between 0 and 1: SELECT RANDOM()

How to Use RANDOM() Function to Get Random in Postgres?

This post presents a comprehensive guide on how to generate random numbers in PostgreSQL. It doesn’t require any argument/parameter. In PostgreSQL, the RANDOM() function can be used to get a random number between a specific range. Postgres offers a built-in RANDOM() function that generates a random numeric value between “0(inclusive)” and “1(exclusive)”.

Generate three random numbers