nikosv wrote:
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
Thank you Nikos.
You walk very patiently through what is not a very intuitive bit of SQL.
If someone can get their head around that they understand a lot.
I also applaud your goal of encouraging set-wise processing instead of row-by-agonizing-row procedural code! :-)
If anyone else has any very apt or concise examples where ANY/ALL make
life easier I'm still keen to see them.
Roy
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)