Hour 8. Using Operators to Categorize Data
What You’ll Learn in This Hour:
• What is an operator?
• An overview of operators in SQL
• How are operators used singularly?
• How are operators used in combinations?
Operators are used in conjunction with the SELECT
command’s WHERE
clause to place extended constraints on data that a query returns. Various operators are available to the SQL user that support all data querying needs. In this hour we will show you what operators are available for you to use as well as how to utilize them properly within the WHERE
clause.
What Is an Operator in SQL?
An operator is a reserved word or a character used primarily in an SQL statement’s WHERE
clause to perform operation(s), such as comparisons and arithmetic ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.