Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number sequence. But there also other ways to accomplish the same thing without using ranking function. I will tell you 3 various ways to generate the unique number sequence including ranking function.
source https://www.c-sharpcorner.com/Blogs/sql-server-various-methods-to-generate-number-sequence
No comments:
Post a Comment