Post
Ask Question

To Find Current Month Data With SQL Query

  1. SELECT Agentname,cast(Sum(agentAmount) as int) as Tolling   
  2. from TABLENAME where datepart(mm,DATEFIELDNAME) =month(getdate())   
  3. and datepart(yyyy,DATEFIELDNAME) =year(getdate())   
  4. group by agentname order by Tolling desc