SQLite expression
An expression is a combination of one or more values, operators, and SQL functions that calculate values.
SQL expressions are similar to formulas and are written in query language. You can also query the database using a specific data set.
Syntax
Assume that the basic syntax of the SELECT statement is as follows:
FROM table_name
WHERE [CONTION | EXPRESSION];
There are different types of SQLite expressions. The specific explanation is as follows:
SQLite - Boolean expression
SQLite’s Boolean expression matches a single Get data based on value. The syntax is as follows:
FROM table_name
WHERE SINGLE VALUE MATCHTING EXPRESSION;
Assume that the COMPANY table has the following records:
1 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
The following example demonstrates the usage of SQLite Boolean expressions:
ID NAME AGE ADDRESS SALARY
---- ------ ---------- ---------- ---------- ----------
4 James 24 Houston 10000.0
SQLite - Numeric Expressions
These expressions are used to perform any mathematical operations in the query. The syntax is as follows:
[FROM table_name WHERE CONDITION] ;
Here, numerical_expression is used for mathematical expression or any formula. The following example demonstrates the use of SQLite numerical expressions:
ADDITION = 21
#There are several built-in Functions, such as avg(), sum(), count(), etc., perform calculations called summary data on a table or a specific table column.
RECORDS = 7
SQLite - Date Expression
Date Expressions that return the current system date and time values can be used in various data operations.
CURRENT_TIMESTAMP = 2013-03-17 10:43:35
