What is the proper syntax to turn this into an UPDATE statement?
I need to set the value of INACTIVE to 1 for all records where the value of VersionRank is greater than one.
I have tried several variations and it keeps setting all the values to 1.
, ROW_NUMBER() OVER (PARTITION BY QUOTE_NUMBER_OEQH
ORDER BY SEQUENCE_NUMBER_OEQH DESC) AS VersionRank
) AS derived