Tag Archives: Count and group by two columns

Here is explanation of Using group by of two columns and count in sql as below, lets say we have two table Emp and Dep. Select * from [dbo].[tblDep] id name 1 IT 2 HR 3 Finance Select * from [dbo].[tblEmp] Empid name Gender depId 1002 Jatin male 1 1003 Nirmal male 1 1004 Aditi… Read More »