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: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (3 / 13) |
Uptime: | 22:12:04 |
Calls: | 8,765 |
Calls today: | 8 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,658 |