SQL in 24 Hours, Sams Teach Yourself, 7th Edition

Hour 13

Using Operators to Categorize Data

What You’ll Learn in This Hour:

• ▶   Defining operators

• ▶   Understanding operators in SQL

• ▶   Using operators singularly

• ▶   Using operators in combinations

Operators are used with the SELECT command’s WHERE clause to place extended constraints on data that a query returns. Various operators are available to SQL users that support all data querying needs. This hour shows you what operators are available for you to use and how to utilize them properly within the WHERE clause.

Defining an Operator in SQL

An operator is a reserved word or character used primarily in a SQL statement’s WHERE clause to perform operation(s) such as comparisons and arithmetic operations. Operators specify conditions in ...