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 variables called the most powerful component of ssis?

0 Answers  

Get Current System Date Time

2 Answers  

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

What do you understand by triggers and mention the different types of it?

0 Answers  

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

Define Check points and End Points?

1 Answers  

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

What are the different acid properties?

0 Answers