SQL
zoo.net
Conditional values
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
SQLite
The SQL Standard is the
CASE statement
SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to SQLite
none
Related links:
FUNCTIONS
Concatenate strings.
Substring: Extracting part of a string.
lower case
Finding a substring in a string
Formatting numbers to two decimal places.
Replace a NULL with a specific value
Conditional values
Get the date and time right now.
Format dates.