use the OR operator to specify that the search must satisfy at least one of the conditions. : OR « Query « SQL Server / T-SQL Tutorial






5>
6>
7> create table Billings (
8>     BankerID           INTEGER,
9>     BillingNumber      INTEGER,
10>     BillingDate        datetime,
11>     BillingTotal       INTEGER,
12>     TermsID            INTEGER,
13>     BillingDueDate     datetime ,
14>     PaymentTotal       INTEGER,
15>     CreditTotal        INTEGER
16>
17> );
18> 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> select * from Billings WHERE BillingTotal < 5000 OR BillingDate <= '2002-07-01'
3> GO
BankerID    BillingNumber BillingDate             BillingTotal TermsID     BillingDueDate          PaymentTotal CreditTotal
----------- ------------- ----------------------- ------------ ----------- ----------------------- ------------ -----------
          1             1 2005-01-22 00:00:00.000          165           1 2005-04-22 00:00:00.000          123         321
          2             2 2001-02-21 00:00:00.000          165           1 2002-02-22 00:00:00.000          123         321
          3             3 2003-05-02 00:00:00.000          165           1 2005-04-12 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
          7             7 2002-07-15 00:00:00.000          165           1 2005-04-19 00:00:00.000          123         321
          8             8 2003-08-16 00:00:00.000          165           1 2005-04-20 00:00:00.000          123         321
          9             9 2004-09-17 00:00:00.000          165           1 2005-04-21 00:00:00.000          123         321
          0             0 2005-10-18 00:00:00.000          165           1 2005-04-22 00:00:00.000          123         321

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








1.20.OR
1.20.1.A search condition that uses the OR operator
1.20.2.use the AND and OR logical operators to create compound conditions that consist of two or more conditions.
1.20.3.use the OR operator to specify that the search must satisfy at least one of the conditions.
1.20.4.The IN operator can be used together with the Boolean operator NOT.