Answer / madhu sudhan g

Hiii

Try this query it will give you the answer


select count(1) as EmpCount,EmployeeName from EMP
GROUP BY DepartmentName

Answer / ramandeep singh

SELECT Dept_Name, dept.Dept_ID, COUNT(*) AS 'no. of
employees' FROM dept
LEFT JOIN emp ON emp.Dept_ID = dept.Dept_ID
GROUP BY dept.Dept_ID, Dept_Name

Answer / sushanta

select dept no, count(dept no)from employee group by dept no.

Answer / rushella

select department_id,count(employee_id) from employees
group by department_id order by department_id;

Answer / ezhumalai

select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID

Answer / eswar mudamanchu

For example i am taking Emp table:

Select Deptid,Count(empid) from Emp
Group By Deptid Order By deptid

Select Location,Count(empid) from Emp
Group By Location Order By Location

Answer / rajkumar v

select Dept_Name,count(Dept_Name) as 'No. of employee'
from tbl_dept group by Dept_Name having COUNT(*)>1

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

What is a join in sql?

0 Answers  

How to test subquery results with the exists operator?

0 Answers  

What are the five characteristics of good data?

0 Answers  

What is an index?

8 Answers   Yardi Software,

Explain index in sql server?

0 Answers  

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

What is DAC? what is the use of it?

1 Answers   Wipro,

What is table level trigger?

0 Answers  

What is buffer cash in sql server?

0 Answers  

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers