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...

Excerpt from BOL ...

Aligned index :

For aligned index ,Index is partitioned in same manner as the base table, using same partition scheme and partitioning column.

When a table and its...