Update SQL column using Rank() function
This is one way:
WITH CTE AS( SELECT FORMULA_ID, ATTRIB_CODE, ATTRIB_VAL, ATTRIB_ORDER, RANK() OVER (PARTITION BY formula_id ORDER BY attrib_code, attrib_val) AS WANT_THIS FROM ATTRIB)UPDATE CTESET ATTRIB_ORDER = WANT_THIS;