• Arsi Salo (4/24/2009)


    ... And now the original correct choice does not give point...:ermm:

    ... which is entirely correct, since the question has been changed to (emphasis mine):

    "What can be the output for this code? (select all that apply)"

    And as already discussed at length in this topic, the query only defines which rows to be returned and not the order, so both versions can be the output (even if only one of them actually is when you run the code).


    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/