I am having a query in sql i.e "select ServiceName,count(_id) from cases groupby ServiceName,_id;"
I want to covert it into mongoDB query language. please help.
The best way would be to get familiar with mongodb docs, particularly the sql to mongo mapping chart.
If you are just looking for a one-time quick-and-dirty solution though, check out querymongo.