O'Reilly logo

Sams Teach Yourself SQL by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required