Learn Sql server in hindi/urdu part-11(Group by in Sql server)

select  count(emp_id),emp_salary from employee group by emp_salary



select count(e.emp_id) as 'Total Employees', d.dept_name from employee e inner join department d on d.dept_id=e.dem_deptid

group by d.dept_name having  count(e.emp_id) >3