• JF1081 (6/25/2010)


    Why is the answer 'C'? Could it be possible that the query would return 'A' or 'B'?

    Possible? I'd say yes, because the results of this kind of query are undefined (see the previous page if this disussion).

    Probable? No, not really. For the reasons mentioned in the explanation of the question.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/