SQLite | SQLite Functions

Tags:

SQLite3 provides useful functions for totals, dates, and other operations. This section explains how to use functions provided by SQLite3 with examples.

SQLite | SQLite Functions | Counting Rows in a Column or Table (count Function)

SQLite | SQLite Functions | Calculate Column Totals with sum and total

SQLite | SQLite Functions | Calculate an Average with avg

SQLite | SQLite Functions | Finding Maximum and Minimum Column Values (max and min Functions)

SQLite | SQLite Functions | Concatenating Column Values (group_concat Function)

SQLite | Functions | Date and Time Functions

SQLite | SQLite Functions | Returning the Number of Characters in a String (length Function)

SQLite | SQLite Functions | Converting Strings to Uppercase or Lowercase (lower and upper Functions)

SQLite | SQLite Functions | Replacing Part of a String (replace Function)

SQLite | SQLite Functions | Extracting Part of a String (substr Function)

SQLite | SQLite Functions | Removing Characters from the Start and End of a String (trim, rtrim, and ltrim Functions)

SQLite | SQLite Functions | Enclosing a String in Single Quotes (quote Function)

SQLite | SQLite Functions | Rounding Numbers (round Function)

SQLite | SQLite Functions | Calculating an Absolute Value (abs Function)

SQLite | SQLite Functions | Generating Random Numbers (random Function)

SQLite | SQLite Functions | Converting a BLOB Value to Hexadecimal (hex Function)

SQLite | SQLite Functions | Generate Random Numbers for BLOB Values (randomblob Function)

SQLite | SQLite Functions | Create a BLOB 0x00 Value of a Specified Number of Bytes (zeroblob Function)

SQLite | SQLite Functions | Count Rows Changed by the Most Recent SQL Statement (changes)

SQLite | SQLite Functions | Count All Rows Changed Since Connecting (total_changes)

SQLite | SQLite Functions | Returning Another Value for NULL (ifnull and coalesce Functions)

SQLite | SQLite Functions | Returning NULL When Values Match (nullif Function)

SQLite | SQLite Functions | Returning the ROWID of the Last Inserted Row (last_insert_rowid Function)

SQLite | SQLite Functions | Returning the Data Type of a Stored Value (typeof Function)

SQLite | SQLite Functions | Query SQLite Version Information (sqlite_version Function)