Post
Ask Question

How To get current Month Data from a table in sql server

  1. select Agentname,cast(Sum(Amount) as int) as Tolling   
  2.   from Maintable where datepart(mm,date) =month(getdate())   
  3. and datepart(yyyy,date) =year(getdate())   
  4.   group by Agentname order by Tolling desc";