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 in 24 Hours, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.