FLOOR SQL function

1. Usage of FLOOR to find approx. full fill units.

SQL Server Query 1

            
SELECT  

    od.OrderID,  

    p.ProductName,  

    od.Quantity,  

    FLOOR(od.Quantity) AS FullUnits  

FROM [Order Details] od  

JOIN Products p ON od.ProductID = p.ProductID  

WHERE od.OrderID IN (10248, 10249, 10250); -- Filter for specific orders for demonstration  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Columns("od.OrderID", "ProductName", "od.Quantity")  

    .Column(new FLOOR(new Column("od.Quantity")), "FullUnits")  

    .From("[Order Details]", "od")  

    .Join(new List<IJoin>()  

    {  

        new Join(SQLJoin.INNERJOIN).TableName(new Table("Products","p"))  

            .On(new Column("od.ProductID"), SQLComparisonOperators.EQUALE_TO, new Column("p.ProductID"))  

    })  

    .Where(new Where(new IN(new Column("od.OrderID"), 10248, 10249, 10250)))  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT od.OrderID,
       ProductName,
       od.Quantity,
       FLOOR(od.Quantity) AS FullUnits
FROM [Order Details] AS od
     INNER JOIN
     Products AS p
     ON od.ProductID = p.ProductID
WHERE od.OrderID IN (@pMAIN_2507200142351969840, @pMAIN_2507200142351969841, @pMAIN_2507200142351969842);


            
        

Parameters (If used)

Query Results 1: