[Eclug] OT: SQL question

  • Previous message: [Eclug] OT: SQL question
  • Next message: [Eclug] OT: SQL question
  • Jack ostroffjh at sbcglobal.net
    Sun Oct 8 18:42:02 EDT 2006

     

    On 2006.10.08 14:42, David Krings wrote:
    > I looked up the operator precedence and found a table that lists
    > levels from 1 through 9 and the corresponding operators. OR was level  
    > 9 and AND was level 8. The description stated that the "higher level  
    > operators have precedence over lower level ones". It did not explain  
    > if level 1 or level 9 is the highest level. So, based on what you  
    > write AND is preferred over OR.
    
    Since I tend not to remember precendence no matter how often I use SQL,  
    I always use enough parentheses to make it obvious how I want things  
    grouped.
    
    

     

     

    More information about the ECLUG mailing list