Author Archives: user

MySQL – UNION Operator Table of content MySQL UNION Operator The UNION operator in MySQL combines the data (without duplicate records) from multiple tables. We can use UNION if we want to select rows one after the other from several tables or several sets of rows from a single table all as a single result […]

MySQL – UNION vs UNION ALL Table of content UNION and UNION ALL operators in MySQL are used to retrieve the rows from multiple tables and return them as one single table. However, for these operators to work on these tables, they need to follow the conditions given below − The tables to be combined […]

MySQL – Having Clause Table of content MySQL Having Clause The MySQL HAVING Clause is used to filter grouped rows in a table based on conditions. This clause is used with the GROUP BY clause to group the rows based on one or more columns and then filter them based on the conditions specified in […]