Logical operators with Parenthesis : Logical Operator « Select Query « SQL Server / T-SQL






Logical operators with Parenthesis


1> CREATE TABLE employee  (emp_no    INTEGER NOT NULL,
2>                         emp_fname CHAR(20) NOT NULL,
3>                         emp_lname CHAR(20) NOT NULL,
4>                         dept_no   CHAR(4) NULL)
5>
6> insert into employee values(1,  'Matthew', 'Smith',    'd3')
7> insert into employee values(2,  'Ann',     'Jones',    'd3')
8> insert into employee values(3,  'John',    'Barrimore','d1')
9> insert into employee values(4,  'James',   'James',    'd2')
10> insert into employee values(5,  'Elsa',    'Bertoni',  'd2')
11> insert into employee values(6,  'Elke',    'Hansel',   'd2')
12> insert into employee values(7,  'Sybill',  'Moser',    'd1')
13>
14> select * from employee
15> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
emp_no      emp_fname            emp_lname            dept_no
----------- -------------------- -------------------- -------
          1 Matthew              Smith                d3
          2 Ann                  Jones                d3
          3 John                 Barrimore            d1
          4 James                James                d2
          5 Elsa                 Bertoni              d2
          6 Elke                 Hansel               d2
          7 Sybill               Moser                d1

(7 rows affected)
1>
2>
8>
9> SELECT * FROM employee
10>         WHERE emp_no = 25348 AND emp_lname = 'Smith'
11>         OR emp_fname = 'Matthew' AND dept_no = 'd1'
12>
13> GO
emp_no      emp_fname            emp_lname            dept_no
----------- -------------------- -------------------- -------

(0 rows affected)
1>
2> SELECT * FROM employee
3>         WHERE ((emp_no = 25348 AND emp_lname = 'Smith')
4>         OR emp_fname = 'Matthew') AND dept_no = 'd1'
5> GO
emp_no      emp_fname            emp_lname            dept_no
----------- -------------------- -------------------- -------

(0 rows affected)
1>
2> drop table employee
3> GO
1>
2>
           
       








Related examples in the same category

1.List of Comparison Operators
2.NOT operator can be replaced by the comparison operator < > (not equal)
3.Use logical operator in where clause
4.Not less than
5.Not greater than
6.Not equal operator in SQL server