Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT t.*,
  2. DENSE_RANK() OVER(PARTITION BY u_a_id, column_name ORDER BY line_num, e_id) AS new_seq_id
  3. FROM tab t;
  4.  
  5. update (SELECT t.*,
  6. DENSE_RANK() OVER(PARTITION BY u_a_id, column_name ORDER BY line_num, e_id) AS new_seq_id
  7. FROM tab t
  8. )
  9. set seq_id = new_seq_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement