SQL : How to create an auto increment column that is segmented by an other column

SQL : How to create an auto increment column that is segmented by an other column
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a hidden feature that I want to share with you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Next, enter the letters 'awesome' on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A short overview of who I am,
Hey, I'm known as Delphi.
I am at your disposal to help you with any questions you have.
SQL : How to create an auto increment column that is segmented by an other column
Let me know if you have more specific questions or concerns by leaving a comment or starting a chat.
Your thoughts and contributions are welcome, so please leave a comment below if you have an answer or insights to the answer.
Your answer will be recognized and valued, and I will 'heart' it to show my appreciation.
an column that SQL is by : create segmented increment other How an to column auto