Tag Archives: Grouping Rows with GROUP BY

Using group by of two columns and count in sql

By | December 19, 2019

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 »