WITH GroupedResults AS (
SELECT w.*,
ROW_NUMBER() OVER (PARTITION BY WorkFlow_ID ORDER BY Approver_Sequence DESC) AS rn
FROM tbl_WorkFlowMembers w
WHERE Division_ID = 'MSV' AND Country_Code = 'MX'
)
No comments:
Post a Comment