SQLite random() function
Description
The random() function returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
Syntax:
random();
SQLite Version: 3.8.5
Example of SQLite random() function
The following SQLite statement returns a random number between -9223372036854775808 and +9223372036854775807.
SELECT QUOTE('w3re''source');
Here is the result
Sample Output:
random() ------------------- 7567341195520768818 sqlite> select random(); random() ------------------- 6027508660740722831 sqlite> select random(); random() ------------------- 6458468859079381942 sqlite> select random(); random() -------------------- -3984338583065376643 sqlite> select random(); random() ------------------- 2368003023800147000 sqlite> select random(); random() ------------------- 9218255973820515681
The above example shows that every time you execute the statement you will get a different result.
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook