MIN SQL function

1. Usage of MIN to find lowest price product

SQL Server Query 1

            
SELECT  

MIN(UnitPrice) AS CheapestPrice  

FROM Products;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Column(new MIN(new Column("UnitPrice")), "CheapestPrice")  

    .From("Products")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT MIN(UnitPrice) AS CheapestPrice
FROM Products;


            
        

Parameters (If used)

Query Results 1:

2. Usage of MIN to find earliest order by customer

SQL Server Query 2

            
SELECT  

    c.CustomerID,  

    c.CompanyName,  

    MIN(o.OrderDate) AS EarliestOrderDate  

FROM Customers c  

JOIN Orders o ON c.CustomerID = o.CustomerID  

GROUP BY c.CustomerID, c.CompanyName;  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select()  

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

    .Column(new MIN(new Column("o.OrderDate")), "EarliestOrderDate")  

    .From("Customers", "c")  

    .Join(new List<IJoin>()  

    {  

        new INNERJOIN().TableName(new Table("Orders","o"))  

            .On(new Column("c.CustomerID").Equale(new Column("o.CustomerID")))  

    })  

    .GroupBy(new GroupBy("c.CustomerID", "c.CompanyName"))  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT c.CustomerID,
       c.CompanyName,
       MIN(o.OrderDate) AS EarliestOrderDate
FROM Customers AS c
     INNER JOIN
     Orders AS o
     ON c.CustomerID = o.CustomerID
GROUP BY c.CustomerID, c.CompanyName;


            
        

Parameters (If used)

Query Results 2: