11 ms·
And that's different from 1 in what way other than being more confusing? Note that in the case you're advocating for, the row number is called "OrderId", which
by thaumasiotes 3y ago
And that's different from 1 in what way other than being more confusing?
Note that in the case you're advocating for, the row number is called "OrderId", which you might have trouble with if you insist on copying a query from somewhere else and using it without modification. Wouldn't you prefer "1"?
- chaps 3y agoIt's helpful within CTEs as a unique identifier. This whole conversation makes me wonder if not many people minmax this sort of meta programming thing.