Database

ANSI SQL Draft 2003 5WD-01-Framework-2003-09.pdf

6.3.3.3 Rule evaluation order

[...].
Where the precedence is not determined by the Formats or by parentheses, effective evaluation of expressions is generally performed from left to right. However, it is implementation-dependent whether expressions are actually evaluated left to right, particularly when operands or operators might cause conditions to be raised or if the results of the expressions can be determined without completely evaluating all parts of the expression.

WHERE NULL = NULL OR 1/0 = 1

jsc42 wrote:

I have not found any specific answer for MySql

SELECT 
	DATE(`MyDateColumn`) AS `Date`, 
	COUNT(`MyDateColumn`) AS `Record count` 
FROM tbl_Pw
WHERE `MyDateColumn` BETWEEN '2023-01-01 00:00:00' AND '2023-03-31 23:59:00'
GROUP BY DATE(`MyDateColumn`)
ORDER BY `MyDateColumn`;

Incorrect datetime value: '2023-06-31 23:59:00'

Member 11533892 wrote:

But I didn't want to divide the execution of the update into 2 variables!!!

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

WITH ctePayments As
(
    SELECT 
        OrderId, 
        PaymentDate,
        Terms, 
        PrevBal, 
        Payment, 
        Balance,
        ROW_NUMBER() OVER (PARTITION BY OrderId ORDER BY PaymentDate DESC) As RN
    FROM 
        OrderPymts
)
SELECT
    O.OrderId,
    O.ClientId,
    O.OrderTotal,
    P.Terms,
    P.PaymentDate,
    P.PrevBal,
    P.Payment,
    P.Balance
FROM
    Orders As O
    INNER JOIN ctePayments As P
    ON P.OrderId = O.OrderId And P.RN = 1
WHERE
    P.Balance >= 0.01
ORDER BY
    O.OrderId
;

SELECT
    O.OrderId,
    O.ClientId,
    O.OrderTotal,
    P.Terms,
    P.PaymentDate,
    P.PrevBal,
    P.Payment,
    P.Balance
FROM
    Orders As O
    CROSS JOIN
    (
        SELECT TOP 1 Terms, PaymentDate, PrevBal, Payment, Balance
        FROM OrderPymts
        WHERE OrderPymts.OrderId = O.OrderId
        ORDER BY PaymentDate DESC
    ) As P
WHERE
    P.Balance >= 0.01
ORDER BY
    O.OrderId
;

public class User
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
    [NotMapped]
    public string FullName { get; set; }  // or whatever your property definition is
}