Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the count() function works in SQLite?

Learn how SQLite count(*) and count(column) differ, how DISTINCT handles duplicates, and how to inspect query plans for count queries.

How the cosh() function works in SQLite?

The SQLite cosh() function is a powerful tool for performing hyperbolic cosine calculations, useful in various mathematical and engineering applications.

How the cos() function works in SQLite?

SQLite’s cos() function enables trigonometric calculations directly within SQL queries.

How the concat() function works in SQLite?

Learn SQLite concat() syntax, NULL handling, version requirements, and how it differs from the || concatenation operator.

How the concat_ws() function works in SQLite?

Learn SQLite concat_ws() syntax, NULL handling, version requirements, and the empty-string bug fixed in SQLite 3.50.2.

How the char() function works in SQLite?

SQLite’s char() function is a powerful tool for constructing strings from ASCII values.

How the coalesce() function works in SQLite?

Learn how SQLite coalesce() chooses the first non-NULL value, when it stops evaluating, and how it relates to ifnull().

How the changes() function works in SQLite?

SQLite’s changes() function is a powerful tool for tracking the impact of data modifications.

How the ceiling() function works in SQLite?

SQLite’s ceiling() function is your reliable partner for conservative number rounding.

How the ceil() function works in SQLite?

The SQLite ceil() function returns the smallest integer value that is greater than or equal to the given numeric expression.