I tink the question must include the collation, because if the collation is case sensitive the answer will be 2.

Really is the most unusual way i have seen, but works!!!

Thanks for your answer

Ok, then we must agree that only two ways exists, The other ways are only variations of the two main ways.

I think there are only 3 ways to asign an alias to a column,

column as alias, alias=column and column alias.

The other variants are diferent ways to write the alias name,...

ColdCofee, I agree with you about the importance of the order in the TOP 1 , but this is not the question in this post, the post is about ...

The order and the TOP 1 does't mather.

If you takes off the TOP 1 the behavior it's still the same.

This Top 1 it's only for safety in the code.

Actually the big companies use the same strategies to avoid responsabilities with the failure of products.

1- If the product fail in Warranty, they change for a new one, the time...