Re: IN clause

["A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx>]

am  Fri, dem 24.11.2006, um 14:42:30 +0530 mailte surabhi.ahuja folgendes:
> Hi,
>  
> i have a table
> and i have the query select * from table where col_name is null;
>  
> it returns some rows
>  
> now, say i have to implement the same query using the in clause how shold it be
> done?
>  
> select * from table where col_name in (null);

select * from table where col_name is null or col_name in (...);

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net