Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update table set Duplicate=1
- WHERE id IN
- ( SELECT id FROM (
- select RANK() OVER (PARTITION BY Hashcode ORDER BY Date asc) R,*
- from table )A where R!=1 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement