RAND

Updated 2023-10-18 15:26:43.480000

Syntax

SELECT [westclintech].[wct].[RAND] ()

Description

Use the scalar function RAND to calculate a random number greater than or equal to zero and less than one.

Return Type

float

Remarks

Unlike the built-in SQL Server RAND function, RAND is evaluated for every row in the resultant table.

Examples

Compare the SQL Server RAND() function to the XLeratorDB RAND() function.

with mycte as
(
      select 1 as seq
      union all
      select seq + 1
      from mycte
      where seq < 15
)
      select seq
      ,rand() as [SQL Server RAND]
      ,wct.rand() as [XLDB RAND]
      from mycte;

Here is the result set (your results will be different).

{"columns":[{"field":"seq","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"SQL Server RAND","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"},{"field":"XLDB RAND","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"seq":"1","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.320075967691334"},{"seq":"2","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.242518944291069"},{"seq":"3","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.939540304240701"},{"seq":"4","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.995485696135315"},{"seq":"5","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.390991905650971"},{"seq":"6","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.847310724479799"},{"seq":"7","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.0338573758405467"},{"seq":"8","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.162934983399244"},{"seq":"9","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.407146586492377"},{"seq":"10","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.186449045740706"},{"seq":"11","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.252528679920915"},{"seq":"12","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.942039038585549"},{"seq":"13","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.857604925612895"},{"seq":"14","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.957765087979192"},{"seq":"15","SQL Server RAND":"0.717683577913778","XLDB RAND":"0.442119654211433"}]}