I don't know if it is interesting,but I've once used ANY to remove duplicate rows https://www.i-programmer.info/programming/database/8296-sql-workshop-removing-duplicate-rows-.html