• I agree that without an ORDER BY clause, the returned result has no meaning.

    but can anyone explain, here in the case of Clustered Index, why it picks third record ?

    Does this depend on Order of Insertion ie., Identity values ?