• Yes, the answer is "Ann". But when you say most of the time we would get “Ann” since the clustered index is created on “first name”.

    Why can’t we say it is always return the “Ann”?

    I did execute the query more than 10 times, all the time the result was “Ann”.

    Just trying to understand, in which scenario SQL Server return different result than “Ann”?

    [font="Calibri"]Raj[/font]