The new column will create an incrementing integer which is basically a pointer to the row number of the results. To do this in MS SQL Server, add the following to the beginning of your column ...

It’s easy to find ... number might cause a problem; you wouldn’t want to invoice a client twice for the same order. These are duplicate records, and you’ll usually want to delete one of ...