Use of a comparison operator in the WHERE clause : Where « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. Where

Use of a comparison operator in the WHERE clause


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

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1> -- Use of a comparison operator in the WHERE clause.
2>
3> SELECT emp_lname, emp_fname FROM employee WHERE emp_no>= 15000
4> GO
emp_lname            emp_fname
-------------------- --------------------

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








Related examples in the same category

1.Query a single row
2.Limiting the Search result using where clause
3.Use variable in where statement
4.Where value 'IS NULL'
5.Using defined variables in where clause
6.WHERE clause conditions can either be simple or contain multiple conditions
7.An expression can also be a part of the condition in the WHERE clause
8.Use query in where clause