排除一定范围的行

以下查询使用关键字 NOT BETWEEN 排除 zipcode 列中字符范围在 94000 到 94999 的行，如下所示。

图: 查询

SELECT fname, lname, city, state
          FROM customer
          WHERE zipcode NOT BETWEEN '94000' AND '94999'
          ORDER BY state;

图: 查询结果

fname           lname           city            state
          
          Frank           Lessor          Phoenix         AZ
          Fred            Jewell          Phoenix         AZ
          Eileen          Neelie          Denver          CO
          Jason           Wallack         Wilmington      DE
          Marvin          Hanlon          Jacksonville    FL
          James           Henry           Brighton        MA
          Bob             Shorter         Cherry Hill     NJ
          Cathy           O'Brian         Princeton       NJ
          Kim             Satifer         Blue Island     NY
          Chris           Putnum          Bartlesville    OK