Re: Number of elements in "IN operator"

Mikhail wrote:

> Does anybody know -how many elements could be in SQL operator IN?.
>
> As an example DELETE FROM emp WHERE ename IN (NULL, 'king',...,N);
>
> Thank you in advance .

I've never run into a limit, but then again I don't make a habit of using long lists of literals. If you use a sub-query i.e.

 DELETE FROM emp WHERE ename IN (SELECT ename from bad_employee);

it's pretty much unlimited (i.e. how much processing power do you have, and how long are you willing to wait.) I've run queries where the sub-query that specifies values for the IN clause returns over half a million rows.

-- 
//-Walt
// Seerch-a zee veb:
// <http://www.google.com/advanced_search?hl=xx-bork>