Articles

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

List Tables in SQL: MySQL, MariaDB, PostgreSQL & More

Compare how to list tables in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, including schema and database scope.

SQL Date Formatting by Database: MySQL, MariaDB, PostgreSQL & More

Compare date and time formatting in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, including the different format tokens.

SQL NULL Handling: COALESCE, IFNULL, ISNULL & NVL by Database

Compare SQL NULL replacement functions across MySQL, PostgreSQL, SQLite, SQL Server, MariaDB, and Oracle, including type precedence and truncation caveats.

SQL String Concatenation: MySQL, PostgreSQL, SQLite, SQL Server & Oracle

Compare SQL string concatenation operators and functions across MySQL, PostgreSQL, SQLite, SQL Server, MariaDB, and Oracle with NULL handling rules.

SQLite PRAGMA index_list: List Indexes and Columns

Use SQLite PRAGMA index_list, index_info, and index_xinfo to list indexes and inspect key, expression, and auxiliary columns.

Top N Rows per Group in SQL: Compare Database Syntax

Compare top-N-per-group SQL in MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Oracle, with ROW_NUMBER, RANK, and tie-handling examples.

SQL Server Error 245: Conversion Failed from varchar to int

Diagnose SQL Server Msg 245 by finding invalid varchar values and implicit conversions, then choose a safe fix with TRY_CONVERT or matching types.

SQL Server Error 515: Cannot Insert NULL into a NOT NULL Column

Diagnose SQL Server Msg 515 by checking the named NOT NULL column, supplied values, omitted columns, and default constraints.

SQL Server Error 8115: Arithmetic Overflow

Diagnose SQL Server Msg 8115 from integer expressions, SUM, AVG, COUNT, and conversions; widen values before the operation.

SQL Server Error 8120: Column Is Not in GROUP BY

Fix SQL Server Msg 8120 by grouping every nonaggregate select expression, choosing a meaningful aggregate, or using a window function.