Discussion Forum | Board Infinity

Group BY and MERGE operation

Data Science/ Machine Learning
#1

Group BY: The GROUP BY statement groups rows that have the same values into summary rows, like find the number of customers in each country.The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.

MERGE:The merge statement is used to make changes in one table based on values matched from another.

1 Like
#2

Also go thorugh https://www.w3schools.com/sql/sql_groupby.asp for simpler understanding
https://www.geeksforgeeks.org/merge-statement-sql-explained/

#3

is there any difference between merge and join in mysql?
And is there any necessary criteria that if you have common field then you can go for join?
let’s consider in case of cross join we don’t need any condition.