SQLite – Page 17

SQLite DATEADD() Equivalent

March 2, 2022 by Ian

SQLite doesn’t have a DATEADD() function like SQL Server (or an ADDDATE() or ADD_DATE() function like in some other DBMSs), but it does have the DATE() function that can make additions to a date value.

SQLite also has a DATETIME() function that can make additions to a datetime value (as well as a TIME() function for time values).

3 Ways to Find Rows that Contain Uppercase Letters in SQLite

March 1, 2022 by Ian

Here are three options for returning rows that contain uppercase characters in SQLite.

11 Ways to Find Duplicate Rows while Ignoring the Primary Key in SQLite

July 23, 2023February 26, 2022 by Ian

Here are eleven options for returning duplicate rows in SQLite when those rows have a primary key or some other unique identifier column (but you want to ignore the primary key).

This means that the duplicate rows share exactly the same values across all columns with the exception of their primary key/unique ID column.

SQLite INTERSECT Operator

February 22, 2022 by Ian

In SQLite, the INTERSECT operator is used to create a compound SELECT statement that returns the intersection of the results of the left and right SELECT statements. In other words, it combines two queries, but returns only those rows that are returned in both queries.

SQLite EXCEPT Operator

February 21, 2022 by Ian

In SQLite, the EXCEPT operator can be used to create a compound SELECT statement that returns the subset of rows returned by the left SELECT that are not returned by the right SELECT.

SQLite UNION Operator

February 20, 2022 by Ian

In SQLite, the UNION operator creates a compound SELECT statement that returns the results of the left and right SELECT statements. In other words, it combines the results from two queries into a single result set.

5 Ways to Select Rows with the Minimum Value for their Group in SQL

July 21, 2023February 16, 2022 by Ian

Here are five options for using SQL to return only those rows that have the minimum value within their group.

These examples work in most major RDBMSs, including MySQL, MariaDB, Oracle, PostgreSQL, SQLite, and SQL Server.

3 Ways to Select the Row with the Minimum Value in SQL

February 15, 2022 by Ian

Here are three examples of using SQL to find and select the row with the minimum value in a given column.

The examples work in most major RDBMSs, including MySQL, MariaDB, PostgreSQL, SQLite, Oracle, and SQL Server.

3 Ways to Find Rows that Contain Lowercase Letters in SQLite

February 9, 2022 by Ian

Here are three options for returning rows that contain lowercase characters in SQLite.

Return Rows that Only Contain Non-Alphanumeric Characters in SQLite

February 6, 2022 by Ian

Here’s an example of returning rows that contain only non-alphanumeric characters in SQLite.

Non-alphanumeric characters include punctuation characters like !@#&()–[{}]:;',?/* and symbols like `~$^+=<>“, as well as whitespace characters like the space or tab characters.