1. You can use the select statement to perform a simple calculation as follow

SELECT
1. You can use the SELECT statement to perform a simple calculation as follow:

2. You can use multiple expressions in the SELECT statement as follows:

We often use the SELECT statement to query data from one or more table
3. Querying data from a single table:

4. You can use the asterisk after SELECT to select all columns of table

ORDER BY
1. We use the ORDER BY clause to sort the result set based on one or more columns in ascending or descending order.
ASC – ascending
DESC – descending.
Default Sort option is ASC.


WHERE


SQLite LIKE