RAND SQL function

1. Usage of RAND to list 5 random products.

SQL Server Query 1

            
SELECT TOP 5 ProductID, ProductName, UnitPrice  

FROM Products ORDER BY RAND();  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select().Top(5)  

    .Columns("ProductID", "ProductName", "UnitPrice")  

    .From("Products")  

    .OrderBy(new OrderBy().Set(new RAND()))  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT TOP 5 ProductID,
             ProductName,
             UnitPrice
FROM Products
ORDER BY RAND() ASC;


            
        

Parameters (If used)

Query Results 1:

2. Usage of RAND to display random numbers.

SQL Server Query 2

            
SELECT TOP 10 RAND() AS RandomNumber,   

	CustomerID, CompanyName, ContactName  

FROM Customers  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select().Top(10)  

    .Column(new RAND(), "RandomNumber")  

    .Columns("CustomerID", "CompanyName", "ContactName")  

    .From("Customers")  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT TOP 10 RAND() AS RandomNumber,
              CustomerID,
              CompanyName,
              ContactName
FROM Customers;


            
        

Parameters (If used)

Query Results 2: