And with parenthesis : Logical operator « Query « SQL Server / T-SQL Tutorial

Home
SQL Server / T-SQL Tutorial
1.Query
2.Insert Delete Update
3.Table
4.Table Join
5.Data Types
6.Set Operations
7.Constraints
8.Subquery
9.Aggregate Functions
10.Date Functions
11.Math Functions
12.String Functions
13.Data Convert Functions
14.Analytical Functions
15.Sequence Indentity
16.View
17.Index
18.Cursor
19.Database
20.Transact SQL
21.Procedure Function
22.Trigger
23.Transaction
24.XML
25.System Functions
26.System Settings
27.System Tables Views
28.User Role
29.CLR
SQL Server / T-SQL Tutorial » Query » Logical operator 
1.26.10.And with parenthesis
2>
3CREATE TABLE authors(
4>    au_id          varchar(11),
5>    au_lname       varchar(40)       NOT NULL,
6>    au_fname       varchar(20)       NOT NULL,
7>    phone          char(12)          NOT NULL DEFAULT ('UNKNOWN'),
8>    address        varchar(40)           NULL,
9>    city           varchar(20)           NULL,
10>    state          char(2)               NULL,
11>    zip            char(5)               NULL,
12>    contract       bit               NOT NULL
13)
14> GO
1insert authors values('1',  'Joe',   'Abra',   '111 111-1111', '6 St.', 'Berkeley',  'CA', '11111', 1)
2insert authors values('2',  'Jack',  'Majo',   '222 222-2222', '3 St.', 'Oakland' ,  'CA', '22222', 1)
3insert authors values('3',  'Pink',  'Cherry', '333 333-3333', '5 Ln.', 'Vancouver', 'BC', '33333', 1)
4insert authors values('4',  'Blue',  'Albert', '444 444-4444', '7 Av.', 'Vancouver', 'BC', '44444', 1)
5insert authors values('5',  'Red',   'Anne',   '555 555-5555', '6 Av.', 'Regina',    'SK', '55555', 1)
6insert authors values('6',  'Black', 'Michel', '666 666-6666', '3 Pl.', 'Regina',    'SK', '66666', 1)
7insert authors values('7',  'White', 'Sylvia', '777 777-7777', '1 Pl.', 'Rockville', 'MD', '77777', 1)
8insert authors values('8',  'Yellow','Heather','888 888-8888', '3 Pu',  'Vacaville', 'CA', '88888', 0)
9insert authors values('9',  'Gold',  'Dep',    '999 999-9999', '5 Av.', 'Oakland',   'CA', '99999', 0)
10insert authors values('10', 'Siler', 'Dean',   '000 000-0000', '4 Av.', 'Oakland',   'CA', '00000', 1)
11> GO

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)

(rows affected)
1>
2>
3>
4SELECT au_lname, au_fname, city, state FROM authors
5WHERE
6(city <> 'OAKLAND' AND state <> 'CA')
7> AND
8(city <> 'Salt Lake City' AND state <> 'UT')
9> GO
au_lname                                 au_fname             city                 state
---------------------------------------- -------------------- -------------------- -----
Pink                                     Cherry               Vancouver            BC
Blue                                     Albert               Vancouver            BC
Red                                      Anne                 Regina               SK
Black                                    Michel               Regina               SK
White                                    Sylvia               Rockville            MD

(rows affected)
1>
2> drop table authors;
3> GO
1.26.Logical operator
1.26.1.The syntax of the WHERE clause with logical operators
1.26.2.A compound condition without parentheses
1.26.3.compound condition with parentheses
1.26.4.three Boolean operations have different priorities for evaluation:
1.26.5.SQL Server evaluates operators in this sequence: (1) NOT, (2) AND, and (3) OR.
1.26.6.Use OR to link two conditions
1.26.7.Use AND to link two conditions
1.26.8.AND, OR without parenthesis
1.26.9.parenthesis with AND, OR
1.26.10.And with parenthesis
1.26.11.Not or
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.