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.
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework