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
| Sysop: | Amessyroom |
|---|---|
| Location: | Fayetteville, NC |
| Users: | 76 |
| Nodes: | 6 (0 / 6) |
| Uptime: | 54:20:33 |
| Calls: | 1,265 |
| Calls today: | 1 |
| Files: | 1,362 |
| D/L today: |
3 files (2,684K bytes) |
| Messages: | 285,563 |