Category Archives: sql

SQL – Wildcards SQL Wildcards SQL Wildcards are special characters used as substitutes for one or more characters in a string. They are used with the LIKE operator in SQL, to search for specific patterns in character strings or compare various strings. The LIKE operator in SQL is case-sensitive, so it will only match strings […]

SQL – MIN() – MAX() function Table of content The MIN() and MAX() functions in SQL are aggregate functions. They are used to compare values in a set and, retrieve the maximum and minimum values respectively. An aggregate function is a mathematical computation that takes a range of values as input and yields a single […]

Left Join vs Right Join Table of content The main difference between the Left Join and Right Join can be observed in the way tables are joined. They are both types of Outer Joins; that is, they retain unmatched rows in one table and discard the unmatched rows of another. Left Join preserves the unmatched […]