Syntax:
SELECT column1, column2, columnN
FROM table_name
WHERE [CONTION | EXPRESSION];
Here we are going to show different types of SQLite expressions, those are mentioned below:
SQLite - Boolean Expressions:
SQLite Boolean Expressions fetch the data on the basis of matching single value. Following is the syntax:
SELECT column1, column2, columnN
FROM table_name
WHERE SINGLE VALUE MATCHTING EXPRESSION;
Consider COMPANY table has the following records:
ID |
NAME |
AGE |
ADDRESS |
SALARY |
1 |
Sanjay |
32 |
Delhi |
20000 |
2 |
Vivek |
25 |
Lucknow |
15000 |
3 |
Bhaskar |
23 |
Kanpur |
20000 |
4 |
Subhash |
25 |
Allahabad |
65000 |
5 |
David |
27 |
Mumbai |
85000 |
6 |
Kim |
22 |
Kerla |
45000 |
7 |
Jagmohan |
24 |
Varanasi |
10000 |
Here is simple examples showing usage of SQLite Boolean Expressions:
sqlite> SELECT * FROM COMPANY WHERE SALARY = 10000;
ID |
NAME |
AGE |
ADDRESS |
SALARY |
7 |
Jagmohan |
24 |
Varanasi |
10000 |
SQLite - Numeric Expression:
syntax:
SELECT numerical_expression as OPERATION_NAME
[FROM table_name WHERE CONDITION] ;
Here, numerical_expression is used for mathematical expression or any formula. Following is a simple example showing usage of SQLite Numeric Expressions:
sqlite> SELECT (15 + 6) AS ADDITION
ADDITION = 21
There are several built-in functions like avg(), sum(), count(), etc., to perform what is known as aggregate data calculations against a table or a specific table column.
sqlite> SELECT COUNT(*) AS "RECORDS" FROM COMPANY;
RECORDS = 7
SQLite - Date Expressions:
Date Expressions return current system date and time values and these expressions will be used in various data manipulations.
sqlite> SELECT CURRENT_TIMESTAMP;
CURRENT_TIMESTAMP = 2013-03-17 10:43:35
0 Comments