Home
SQL / MySQL
Aggregate Functions
Backup Load
Command MySQL
Cursor
Data Type
Database
Date Time
Engine
Event
Flow Control
FullText Search
Function
Geometric
I18N
Insert Delete Update
Join
Key
Math
Procedure Function
Regular Expression
Select Clause
String
Table Index
Transaction
Trigger
User Permission
View
Where Clause
XML
RAND « Function « SQL / MySQL
SQL / MySQL
Function
RAND
1.
Each time you seed the generator with a given value, RAND( ) will produce a repeatable series of numbers:
2.
Selection with a random Column
3.
To select a single winner at random from the combined results of the three tables
4.
Generating Random Numbers
5.
Seed RAND( ) randomly
6.
Randomizing a Set of Rows
7.
Add a column of random numbers to the column output list, alias it, and refer to the alias for sorting
8.
Selecting Random Items from a Set of Rows
9.
To draw five winning entries at random from a table named drawing that contains contest entries, use RAND( ) i
10.
get some random numbers
11.
Get some random numbers in the range 1-100
12.
Get the name and the number of each player whose name consists of the pattern m.n. The point can be any random