SQL Bootcamp: Learn the Basics of SQL Programming in 2 Weeks (2016)

Chapter 6. The SQL Expressions

Basically, an expression is a group of values, functions, and operators. SQL expressions can help you evaluate database values.

In this computer language, an expression is a formula that you must write using a query language. You may also use an expression to run a database query for certain pieces of information.

The Syntax

Here is the format of the SELECT command:

Now, let’s talk about the expressions supported by SQL:

The Boolean Expressions – These expressions retrieve data by matching a single value. Here is the basic syntax of a Boolean expression:

The Numeric Expressions – You can use these expressions to conduct mathematical operations in your database queries. Here is the syntax that you should use:

The Date Expressions– These expressions give you the time and date information of your system.