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

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

what is checksum in sql server.........???

0 Answers   TCS,

What’s the use of custom fields in report?

0 Answers  

What is raid? : SQL Server Architecture

0 Answers  

Explain what are commit and rollback in sql?

0 Answers  

What is a full text index?

0 Answers  

Mention the uses of stored procedures.

0 Answers  

Explain the steps to use transact-sql cursor?

0 Answers