Try to write the query in sql server.

Question

Table 1 (id ,empname ,deptid  ) Table 2( deptid ,deptname ).Write the query for count the no.of employees in each department its showing with dept name.

Suman Kumar Singh · Answer

Select deptid from table 1;

Anurag Sharma · Answer

SELECT COUNT(*) AS 'No. of Employees', Dept.Deptname as 'Department Name'FROM Table1 AS empINNER JOIN Table2 as deptON emp.deptid = dept.deptidGROUP BY dept.deptname

Mudassir Ahmed · Answer

SELECT COUNT(*) AS COUNT,dept.deptname FROM Table1 AS empINNER JOIN Table2 as dept ON emp.deptid = dept.deptid GROUP BY dept.deptname

Dharmendra Kumar Jain · Answer

SELECT  DEPTNAME ,  COUNT(DISTINCT T1.ID) FROM TABLE1 T1 INNER JOIN TABLE2  T2 ON T1.DEPID=T2.DEPIDGROUP  BY  DEPTNAMEORDER BY DEPTNAME

Priyanka Ananta Khamkar · Answer

select dept.deptId, deptName, count(emp.empid) as numb_of_emps from department dept inner join employee emp on dept.deptid = emp.deptid group by dept.deptid

Aanchal Mathur · Answer

SELECT COUNT(*) AS COUNT,dept.deptname FROM Table1 AS empINNER JOIN Table2 as dept ON emp.deptid = dept.deptid GROUP BY dept.deptname >

Aashish Singh Rawat · Answer

SELECT COUNT(*) AS COUNT,dept.deptname FROM Table1 AS empINNER JOIN Table2 as dept ON emp.deptid = dept.deptid GROUP BY dept.deptname