Chapter 8. Using Operators to Categorize Data

Operators are used in conjunction with the SELECT command to place extended criteria on data that is returned by a query. Various operators are available to the SQL user that support all data querying needs.

The highlights of this hour include:

  • What is an operator?

  • An overview of operators in SQL

  • How are operators used singularly?

  • How are operators used in combinations?

What Is an Operator in SQL?

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

The operators discussed ...

Get Sams Teach Yourself SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.