Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    5

    Unanswered: Comparison between 2 queries

    Can anyone help me to understand the relationship/difference between the below 2 query conditions, with slightly explanation for both.

    1) SELECT ......... where NOT (invoice_total >=5000 OR NOT invoice_date <= '01-Jul-2008')


    2) SELECT .......... WHERE invoice_total <5000 AND invoice_date <= '01-Jul-2008'


    *** the reference book from where i got it, says both are same. But i am a bit confused bcoz inside parenthesis invoice_date isn't supposed to be > in the 2nd query, as NOT is used before that?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    Both are the same, think "algebra 101".
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •