Re: id <> '2'

hillmw_at_charter.net says...
> nvl works great!!!

There are (as per the other responses) actually a myriad of ways to get the result you want, and which to choose will depend on the structure (number of rows, cardinality, etc.) of your data.

For example, another option:

select *
from mytable
minus
select *
from mytable
where id=2

Geoff M Received on Wed Sep 21 2005 - 18:13:29 CDT