08-SQLite in, between, alias, 08-sqlitealias

08-SQLite in, between, alias, 08-sqlitealias
I. in operator Overview

The IN operator allows us to specify multiple values IN the WHERE clause.
Syntax: select column_name from table_name where column_name in (value1, value2 ,...);
Example 1: Search for lucy and bob data in the name column from the persons table.

2. between Operator

The between operator... and selects a data range between two values. These values can be numerical values, text values, or dates.
Syntax: select column_name from table_name where column_name between value1 and value2
Example 1: Select data information in the name column from persons in alphabetical order between "bob" and "com"

Example 2: select the data information in the id column from pesons in numerical order between 2 and 3

Iii. alias Operators

You can specify an alias for the column name and table name.

Syntax: select column_name as alias_name from table_name;

Example 1: Set the name in the persons table to alias_name.