Day 3. Expressions, Conditions, and Operators
On Day 2, “Introducing the Query,” you used SELECT and FROM to manipulate data in interesting (and useful) ways. Today 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. When the sun sets on Day 3, 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
Note
We used Oracle's Personal Oracle and MySQL to generate today's examples. Other implementations of SQL may differ slightly in ...
Get Sams Teach Yourself SQL in 21 Days, 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.