LESSON 3Expressions, Conditions, and Operators
In Lesson 2, “Introducing the Query,” you used SELECT and FROM to manipulate data in interesting (and useful) ways. In this lesson, you learn more about SELECT and FROM. You will expand the basic query with some new terms, a new clause, and a group of handy items called operators. By the end of this lesson, you will
• Know what an expression is and how to use it.
• Know what a condition is and how to use it.
• Be familiar with the basic uses of the WHERE clause.
• Be able to use arithmetic, comparison, character, logical, and set operators.
• Have a working knowledge of some miscellaneous operators.
Get Sams Teach Yourself SQL in One Hour a Day, 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.
