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

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

How to recompile stored procedure at run time?

0 Answers  

Write a SQL query to delete a table?

0 Answers   Amdocs,

Explain ranking functions?

0 Answers  

can you any body tell me the difference between candidate key and primary key

4 Answers  

What is row by row processing ?

2 Answers  

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

What is database mirroring?

0 Answers  

Explain what are db_options used for?

1 Answers   InterGraph,

How to select some specific rows from a table in ms sql server?

0 Answers  

What does truncate do?

0 Answers