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 readingIn PostgreSQL, the EXCEPT operator returns rows that are returned by the left input query that aren’t returned by the right input query. This can also be referred to as the difference between two queries.
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 readingIn Oracle Database, the UNION operator allows us to combine the results from two queries into a single result set.
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 readingHere are three options for returning rows that contain lowercase characters in SQLite.
Continue readingIn 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).
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 readingHere are three examples of returning a list of stored procedures that reference a specific table in PostgreSQL.
Continue readingHere are three options for listing out the triggers for a given table in PostgreSQL.
Continue reading