Tricks and tips

SQL

Permut two rows according to their id

Goal: permut two rows with id=a and id=b using only one query

UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)