SQL SERVER – Generating Row Number Without Ordering Any Columns

(Pinal Dave) Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order.

Read More - Register for Free Membership