Re: Which of the two statements do you find is easier to understand?

Actually I was thinking of going with #2 until I posted this. It's seem
almost unanimous that #1 is easier to understand. So now I'm going with #1
based on popular opinion.

Thanks all for the sanity check.
Mike

On Fri, May 6, 2011 at 11:46 AM, Jared Still <jkstill@xxxxxxxxx> wrote:

> On Fri, May 6, 2011 at 11:08 AM, Rich Jesse <
> rjoralist2@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
>> Michael writes:
>>
>> > Which of the two statements do you find is easier to understand?
>> >
>> > WHERE (txv.business_unit2tcode NOT IN (41940)
>> >         OR (txv.business_unit2tcode IN (41940) AND txv.ext_source_key IS
>> > NULL));
>>
>> I'll take what's behind Door #3:
>>
>>    WHERE txv.business_unit2tcode != 41940 OR txv.ext_source_key IS NULL;
>>
>> Simple, to the point, and logically equivalent to your first WHERE clause.
>>
>>
> Agreed.
>
> One would hope this is SQL that is run infrequently...
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>

Other related posts: