SQL update order in relation ship based on ID

I wonder how to update order in this table for many-to-many relationship using SQL based on PostsId. So my table now looks like: I’m using SQL Server BlogsId PostsId Order 1 1 1 0 2 2 1 0 3 3 2 0 3 4 2 0 3 5 3 0 3 6 3 0 but
Read More »