Doubt about System_Row# with ORDER BY

[HugoGalindo]

If I use System_Row# in a SELECT with ORDER BY, can I assume that the System_Row# will always match the requested order?

Table1:
Col1
---
C
B
A

SELECT System_Row# AS ID, * FROM Table1 ORDER BY Col1;

Result:
ID Col1
-- ---
1 A
2 B
3 C

This will always be the result? or there is a chance that the System_Row# could be applied before the table is ordered? (As happen with IDENTITY in MySQL http://support.microsoft.com/kb/273586/en-us?fr=1)

> If I use System_Row# in a SELECT with ORDER BY, can I assume that the
> System_Row# will always match the requested order?

Yes; it is processed after any ORDER BY clause.


--
Eivind Bakkestuen [NDD]