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

What is candidate key with example?

0 Answers  

Explain how to integrate the ssrs reports in application?

0 Answers  

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

How to create an index on a view?

0 Answers  

How to connect sql server management studio express to sql server 2005 express?

0 Answers  

How to make a remote connection in a database?

0 Answers  

What are the different types of subquery?

0 Answers  

Tell me about Triggers?

3 Answers   Cap Gemini,

what is difference between view and Dip.

0 Answers   IBM, L&T,

what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  

How does normalization work?

0 Answers  

Why use identity in sql server?

0 Answers