How to Add a Row Number to Your SQL Query Using row_number and partition by

In this episode, we'll take a look at how to add a row number to our query so that we can refer to that ordering when we use the data for other purposes. In order to do this, we're going to use two very important features of sql: row_number and partition by. Using these, we'll create a row number column for the whole column, and then split up our data and give a row number inside of those groups.

Needing to hire technical resources for your project? Get the best:

For developers looking for a new role, check out:

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

[Oleemil]

Nice video! I enjoyed the intro song, but people have different expectations i guess. Who is playing and what song is it? Had a nice riff

[sonathena]

Hello Sean, do you have a copy of the dataset in this discussion? I hope you do have so we can try it by ourselves. Thanks

[DCh-ksug]

is it necessary to use order by function in the row_number function ?

[maheshs]

Sir, will these rownum work for table with million record

[anilmanuka]

How to update empty column a value in declare table

[diegovaldes]

is there a way that the row number continues the sequence after running the same query again?

[alekkermd]

The background music is very distracting.