SQLite Expressions

SQLite Expressions are the combination of one or more values, operators and SQL functions. These expressions are used to evaluate a value.

SQLite expressions are written in query language and used with SELECT statement.

Syntax:

snippet
SELECT column1, column2, columnN 
FROM table_name 
WHERE [CONDITION | EXPRESSION];

There are mainly three types of SQLite expressions:

1) SQLite Boolean Expression

SQLite Boolean expressions are used to fetch the data on the basis of matching single value.

Syntax:

snippet
SELECT column1, column2, columnN 
FROM table_name 
WHERE SINGLE VALUE MATCHTING EXPRESSION;

Example:

We have an existing table named "STUDENT", having the following data:

Sqlite Expressions 1

See this simple example of SQLite Boolean expression.

snippet
SELECT * FROM STUDENT WHERE FEES = 20000;

Output:

Sqlite Expressions 2

2) SQLite Numeric Expressions

SQLite Numeric expression is used to perform any mathematical operations in the query.

Syntax:

snippet
SELECT numerical_expression as  OPERATION_NAME
[FROM table_name WHERE CONDITION] ;

Example1:

SELECT (25 + 15) AS ADDITION;

Output:

Sqlite Expressions 3

Numeric expressions contain several built-in functions like avg(), sum(), count(), etc. These functions are known as aggregate data calculation functions.

SELECT COUNT(*) AS "RECORDS" FROM STUDENT;

Output:

Sqlite Expressions 4

3) SQlite Date Expression

SQlite Date expressions are used to fetch the current system date and time values.

Syntax:

snippet
SELECT CURRENT_TIMESTAMP;

SELECT CURRENT_TIMESTAMP;

Output:

Sqlite Expressions 5
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents