A search condition that uses the NOT operator : Not « Query « SQL Server / T-SQL Tutorial






5>
6> create table Billings (
7>     BankerID           INTEGER,
8>     BillingNumber      INTEGER,
9>     BillingDate        datetime,
10>     BillingTotal       INTEGER,
11>     TermsID            INTEGER,
12>     BillingDueDate     datetime ,
13>     PaymentTotal       INTEGER,
14>     CreditTotal        INTEGER
15>
16> );
17> GO
1>
2> INSERT INTO Billings VALUES (1, 1, '2005-01-22', 165, 1,'2005-04-22',123,321);
3> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (2, 2, '2001-02-21', 165, 1,'2002-02-22',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (3, 3, '2003-05-02', 165, 1,'2005-04-12',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (4, 4, '1999-03-12', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (5, 5, '2000-04-23', 165, 1,'2005-04-17',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (6, 6, '2001-06-14', 165, 1,'2005-04-18',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (7, 7, '2002-07-15', 165, 1,'2005-04-19',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (8, 8, '2003-08-16', 165, 1,'2005-04-20',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (9, 9, '2004-09-17', 165, 1,'2005-04-21',123,321);
2> GO

(1 rows affected)
1> INSERT INTO Billings VALUES (0, 0, '2005-10-18', 165, 1,'2005-04-22',123,321);
2> GO

(1 rows affected)
1>
2>
3> select * from Billings WHERE NOT (BillingTotal >= 5000 OR NOT BillingDate <= '2002-07-01')
4> GO
BankerID    BillingNumber BillingDate             BillingTotal TermsID     BillingDueDate          PaymentTotal CreditTotal
----------- ------------- ----------------------- ------------ ----------- ----------------------- ------------ -----------
          2             2 2001-02-21 00:00:00.000          165           1 2002-02-22 00:00:00.000          123         321
          4             4 1999-03-12 00:00:00.000          165           1 2005-04-18 00:00:00.000          123         321
          5             5 2000-04-23 00:00:00.000          165           1 2005-04-17 00:00:00.000          123         321
          6             6 2001-06-14 00:00:00.000          165           1 2005-04-18 00:00:00.000          123         321

(4 rows affected)
1>
2> drop table Billings;
3> GO
1>








1.21.Not
1.21.1.use the NOT operator to negate a condition.
1.21.2.A search condition that uses the NOT operator
1.21.3.The same condition rephrased to eliminate the NOT operator
1.21.4.The condition 'column IS NOT NULL' is equivalent to the condition 'NOT (column IS NULL)'
1.21.5.The use of the LIKE operator (together with NOT).
1.21.6.NOT BETWEEN