Re: SQLPLUS Oracle 8i query
From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Fri, 21 Jul 2006 14:12:41 +0200
Message-ID: <44c0c4ae$0$163$a3f2974a_at_nnrp1.numericable.fr>
Date: Fri, 21 Jul 2006 14:12:41 +0200
Message-ID: <44c0c4ae$0$163$a3f2974a_at_nnrp1.numericable.fr>
Cris Carampa wrote:
> select * from tablename
> where
> country = 'abc' and
> (
> (region='pqr' and city='xyz')
> or
> (region!='pqr')
> )
That query can be simplified as follows:
select * from tablename where country='abc' and (city='xyz' or region<>'pqr'); Received on Fri Jul 21 2006 - 14:12:41 CEST