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 […]
Category Archives: sql
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 […]
SQL – UNION vs UNION ALL Table of content UNION and UNION ALL operators are just the SQL implementation of algebraic set operators. Both of them are used to retrieve the rows from multiple tables and return them as one single table. The difference between these two operators is that UNION only returns distinct rows […]