In Oracle Database, the UNION operator allows us to combine the results from two queries into a single result set.
DBMS
Database Management Systems
4 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.
3 Ways to Find Rows that Contain Lowercase Letters in SQLite
Here are three options for returning rows that contain lowercase characters in SQLite.
MariaDB 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.
3 Ways to List All Stored Procedures that Reference a Table in PostgreSQL
Here are three examples of returning a list of stored procedures that reference a specific table in PostgreSQL.
3 Ways to List all Triggers for a Given Table in PostgreSQL
Here are three options for listing out the triggers for a given table in PostgreSQL.
Return Rows that Only Contain Non-Alphanumeric Characters in SQLite
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.
MariaDB INTERSECT Operator Explained
In MariaDB, the INTERSECT operator intersects two queries and returns only those rows that are returned in both queries.
It returns all rows from the left SELECT result set that are also present in the right SELECT result set.