In MySQL, the UNION clause combines the results from multiple queries into a single result set.
Category: Relational
3 Ways to Select the Row with the Minimum Value in SQL
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.
Continue readingSHOW TABLES in MariaDB
In MariaDB, SHOW TABLES is an administrative statement that lists the non-TEMPORARY tables, sequences and views in a given database.
7 Ways to Find Duplicate Rows in SQL Server while Ignoring any Primary Key
Here are seven options for finding duplicate rows in SQL Server, when those rows have a primary key or other unique identifier column.
In other words, the table contains two or more rows that share exactly the same values across all columns except for its unique identifier column.
Continue readingFind All Non-Numeric Values in a Column in MariaDB
If you ever encounter a character column that should be a numeric column, there’s always a possibility that it contains non-numeric data that you don’t know about.
In MariaDB, you can run a query like the following to return non-numeric data from the column.
Continue reading4 Functions to Format a Number to 2 Decimal Places in SQL Server
When using T-SQL with SQL Server, we can format numbers using various methods, depending on our desired format.
Below are four functions that can be used to format a number to two decimal places in SQL Server.
Continue reading3 Ways to Find Rows that Contain Lowercase Letters in SQLite
Here are three options for returning rows that contain lowercase characters in SQLite.
Continue readingMariaDB MINUS Operator Explained
In MariaDB, the MINUS operator returns distinct rows from the left input query that aren’t output by the right input query.
The MINUS operator was introduced in MariaDB 10.6.1 as a synonym for the EXCEPT operator for the purposes of compatibility with Oracle. Therefore, we can use MINUS and EXCEPT interchangeably (in MariaDB 10.6.1 and later).
4 Ways to Check for Duplicate Rows in SQL Server
Here are four methods you can use to find duplicate rows in SQL Server.
By “duplicate rows” I mean two or more rows that share exactly the same values across all columns.
Continue readingMariaDB UNION Operator Explained
In MariaDB, the UNION operator combines the results from multiple SELECT statements into a single result set.