here I have table X that comes from certain operation where step_order is not start from 1...here order can start from > 1..but in sequence (e.g, 5,6,7) and row number can vary...hence how can I reset/update the order from 1...please help
CREATE TABLE X(STEP_NAME VARCHAR(50), STEP_ORDER INT)
INSERT INTO X VALUES ('A', 5)
INSERT INTO X VALUES ('B', 6)
INSERT INTO X VALUES ('C', 7)
SELECT * FROM X
/**************************
OUTPUT OF TABLE X,
STEP_NAME STEP_ORDER
A 5
B 6
C 7
**************************/
/**************************
HOW TO UPDATE TABLE X FOR BELOW
EXPECTED OUTPUT - RE-ORDER,
STEP_NAME STEP_ORDER
A 1
B 2
C 3
**************************/

**View Complete Post**

## Dimensions order in excel pivotal table