Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    SQL Rand Function

    Uploaded by

    Krishna Kumar Gupta
    The document discusses the RAND function in SQL which produces random numbers and can be used to randomize the order of rows in a table by using ORDER BY RAND(). RAND() without a seed generates random numbers between 0 and 1, while providing a seed value makes the random numbers predictable and repeatable.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    SQL Rand Function

    Uploaded by

    Krishna Kumar Gupta
    24 views2 pages
    The document discusses the RAND function in SQL which produces random numbers and can be used to randomize the order of rows in a table by using ORDER BY RAND(). RAND() without a seed generates random numbers between 0 and 1, while providing a seed value makes the random numbers predictable and repeatable.

    Original Description:

    sql

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses the RAND function in SQL which produces random numbers and can be used to randomize the order of rows in a table by using ORDER BY RAND(). RAND() without a seed generates random numbers between 0 and 1, while providing a seed value makes the random numbers predictable and repeatable.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    24 views2 pages

    SQL Rand Function

    Uploaded by

    Krishna Kumar Gupta
    The document discusses the RAND function in SQL which produces random numbers and can be used to randomize the order of rows in a table by using ORDER BY RAND(). RAND() without a seed generates random numbers between 0 and 1, while providing a seed value makes the random numbers predictable and repeatable.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    SQL - RAND FUNCTION

    http://www.tuto rialspo int.co m/sql/sql-rand-functio n.htm

    Co pyrig ht tuto rials po int.co m

    SQL has a RAND function that can be invoked to produce random numbers between 0 and 1:
    SQL> SELECT RAND( ), RAND( ), RAND( );
    +------------------+-----------------+------------------+
    | RAND( )
    | RAND( )
    | RAND( )
    |
    +------------------+-----------------+------------------+
    | 0.45464584925645 | 0.1824410643265 | 0.54826780459682 |
    +------------------+-----------------+------------------+
    1 row in set (0.00 sec)

    When invoked with an integ er arg ument, RAND( ) uses that value to seed the random number g enerator. Each
    time you seed the g enerator with a g iven value, RAND( ) will produce a repeatable series of numbers:
    SQL> SELECT RAND(1), RAND( ), RAND( );
    +------------------+------------------+------------------+
    | RAND(1 )
    | RAND( )
    | RAND( )
    |
    +------------------+------------------+------------------+
    | 0.18109050223705 | 0.75023211143001 | 0.20788908117254 |
    +------------------+------------------+------------------+
    1 row in set (0.00 sec)

    You can use O RDER BY RAND() to randomize a set of rows or values as follows:
    T o understand O RDER BY RAND() function, consider an employee_tbl table, which is having the
    following records:
    SQL> SELECT * FROM employee_tbl;
    +------+------+------------+--------------------+
    | id
    | name | work_date | daily_typing_pages |
    +------+------+------------+--------------------+
    |
    1 | John | 2007-01-24 |
    250 |
    |
    2 | Ram | 2007-05-27 |
    220 |
    |
    3 | Jack | 2007-05-06 |
    170 |
    |
    3 | Jack | 2007-04-06 |
    100 |
    |
    4 | Jill | 2007-04-06 |
    220 |
    |
    5 | Zara | 2007-06-06 |
    300 |
    |
    5 | Zara | 2007-02-06 |
    350 |
    +------+------+------------+--------------------+
    7 rows in set (0.00 sec)

    Now, use the following commands:


    SQL> SELECT * FROM employee_tbl ORDER BY RAND();
    +------+------+------------+--------------------+
    | id
    | name | work_date | daily_typing_pages |
    +------+------+------------+--------------------+
    |
    5 | Zara | 2007-06-06 |
    300 |
    |
    3 | Jack | 2007-04-06 |
    100 |
    |
    3 | Jack | 2007-05-06 |
    170 |
    |
    2 | Ram | 2007-05-27 |
    220 |
    |
    4 | Jill | 2007-04-06 |
    220 |
    |
    5 | Zara | 2007-02-06 |
    350 |
    |
    1 | John | 2007-01-24 |
    250 |
    +------+------+------------+--------------------+
    7 rows in set (0.01 sec)
    SQL> SELECT * FROM employee_tbl ORDER BY RAND();
    +------+------+------------+--------------------+
    | id
    | name | work_date | daily_typing_pages |
    +------+------+------------+--------------------+
    |
    5 | Zara | 2007-02-06 |
    350 |
    |
    2 | Ram | 2007-05-27 |
    220 |
    |
    3 | Jack | 2007-04-06 |
    100 |

    |
    1 | John | 2007-01-24 |
    250 |
    |
    4 | Jill | 2007-04-06 |
    220 |
    |
    3 | Jack | 2007-05-06 |
    170 |
    |
    5 | Zara | 2007-06-06 |
    300 |
    +------+------+------------+--------------------+
    7 rows in set (0.00 sec)

    You might also like