We've come at last to the point where we can begin showing you the most important aspect of SQL — how to query your "database". In this chapter, we'll begin by describing simple search conditions.
-
Truth Values
In our chapter on the Boolean <data type>, we noted what SQL's truth values... -
SELECT Statement
The SELECT statement retrieves data from one or more Tables. Here is the re... -
Predicates
You'll have noticed by now that the fundamental SQL condition is the predic... -
Search Conditions
A search condition consists of one or more Boolean value expressions. A Boo... -
SQL's <case expression>
The CASE expression is not a filtering operation, but it fits in this conte... -
Dialects
The truth is, most vendors are just starting to get used to the SQL-92 sear...
