[Info-ingres] ANY and ALL

[Roy Hann]

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