• Good question - but, I think the answers and explanation are lacking.

    The order of the clustered index is based upon the columns which make up the clustered index. (Change the field on the index to see this work.) The order is also based upon the collation of the database as well (simple enough to test, but add more data for a real test). Thus the TOP record returned is determined by these factors.

    Thus, without any other definition of the collation, I would have to agree with those calling for an It depends answer.

    Some good information can bee seen at http://msdn.microsoft.com/en-us/library/cc917672.aspx

    Additional reading: http://msdn.microsoft.com/en-us/library/ms177443.aspx

    or http://searchsqlserver.techtarget.com/tip/Clustered-and-non-clustered-indexes-in-SQL-Server

    There are many other references out there as well.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan