Author Archives: user

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 […]

MySQL – GROUP BY Clause Table of content MySQL GROUP BY Clause The GROUP BY clause in MySQL is used to arrange identical data in a table into groups. For example, let us suppose you have a table of sales data of an organization consisting of date, product, and sales amount. To calculate the total […]

MySQL – Clustered Index Indexes in MySQL are used to retrieve the data much faster from the database. We (users) cannot see the indexes, but they work behind to speed up searches and queries. They are categorized into two types: clustered and non-clustered indexes. A clustered index can sort the data in a table manually. […]