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

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

What are types of scd? : sql server analysis services, ssas

0 Answers  

What is a group function explain with an example?

0 Answers  

What are the different types of triggers in SQL SERVER?

0 Answers  

What is difference between delete & truncate commands?

0 Answers  

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

What does top operator do?

0 Answers  

find the 3rd max salary

10 Answers  

explain different levels of normalization? : Sql server database administration

0 Answers  

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

CTE(common table expression)

1 Answers   Thomson Reuters,

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,