SQL Group by

SQL Group by clause is frequently used term in database world.This video describes concept deeply and discusses important interview questions as well. Group by clause is used to make groups of similar rows. It is generally used with aggregate functions like min,max,sum,avg etc. We get different results if we group rows by one column and if we group by more than one column. This is because it considers values of more than one column to form a group in case of group by clause with more than one column. Below are some important interview questions regarding group by clause: • What is Group by clause ? How does it work ? • When do we use Group by clause ? • How does Group by handle NULL values ? • What is difference between Group by and Having clause ? • How can we select unique column values without using distinct ? • How can we find the duplicate values from particular column of table ? • Find the max salary of emp department wise. • Find Emp details(Name,Id,City) who has max Salary in each department. • Find name of cities where more than 2 employees come(live) from. #sql,#database,#Group by ,#Group by clause,#having filter,#maximum salary, #sql group by clause,#database interview questions Please subscribe my channel @datadeepdive759 https://www.youtube.com/@datadeepdive759