Mastering GUI Programming with Python

Selecting data

Probably the most important operation in SQL is the SELECT statement, which is used to retrieve data. A simple SELECT statement looks like this:

SELECT reviewer, review_dateFROM reviewsWHERE  review_date > '2019-03-01'ORDER BY reviewer DESC;

The SELECT command is followed by a list of fields, or by the * symbol, which means all fields. The FROM clause defines the source of the data; in this case, the reviews table. The WHERE clause, once again, defines conditions that must be true for the rows to be included. In this case, we'll only include reviews newer than March 1, 2019, by comparing each row's review_date field (which is a DATE type) to the string '2019-03-01' (which SQLite will convert to a DATE to make the comparison). ...