I don't see how "Order By" will work. Sequence# = NextStep#. In the second table the sequence# is not in numerical order. If I am missing something then perhaps you can send the SQL code that will select from table 1 and output table 2.
I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. I want to re-arrange them in next step order.
If we start with the first table below, the query should generate the second table below. It does not matter if we...
I have modified the requirement to include a row number column at the beginning of each table.
I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. We want them re-arranged in next step order.
If we start with the...
I want to use SQL to re-arrange the records in a table. In the first table below, the records are arranged in numerical step order. We want them re-arranged in next step order.
If we start with the first table below, the query should generate the second table below. It does not matter if we...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.