Sample Video Frame

Created by Zed A. Shaw Updated 2024-02-17 04:54:36

Exercise 19: Logic and Math Expressions

The SQLite3 language supports many more functions to handle math, string manipulation, grouping, types, and other features in the SQLite3 Core Functions documentation. The only catch is sometimes you'll want to use the AS keyword to assign these results to a fake column name. It's best to always give math expressions a column name with AS from now on, but if you ever type out an expression and don't see it, that's why. To use AS just do this:

Previous Lesson Next Lesson

Register for Learn SQL the Hard Way

Register today for the course and get the all currently available videos and lessons, plus all future modules for no extra charge.