Maximum of count(*)

[Raparla]

Hi,

Any idea on how to find, in which month the maximum number of employees joined the company.

Table has two fields Month, Emp_Id

You can use the following as prototype.

select Month_Name, max(count(Emp_Id)) from Table1
group by Month_Name

 

[karluk]

I would try something like

SELECT top 1 month,COUNT(emp_id) FROM table1
GROUP BY month
order by 2 desc

 

[Raparla]

Thank You. It is working fine.