ROW_NUMBER() - Order by Row order - not value?

I have a SQL 2005 query - with a ROW_NUMBER() - I do not want to order by any value - just by the default order of the rows returned - is that possible?
tbaseflugAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes, then in the ORDER BY clause just place your Primary Keys or Clustered index key columns alone which would do as required.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.