group by date problem giving multiple entries [Resolved]

Posted by RohiK under Sql Server on 11/9/2011 | Points: 10 | Views : 2128 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

I have many entries everyday, I want to calculate how many entries per day

I used

select count(*), date from entries group by date

how to calculate?

Happy Programming!!
Rohi

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Niladri.biswas on: 11/14/2011 [Member] Platinum | Points: 50

0	I believe it is happening as because the time componenet is also coming into picture. Use only the date componenet and that will serve the purpose Best Regards, Niladri Biswas RohiK, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Blessyjees on: 11/9/2011 [Member] Bronze | Points: 25

0	Hi, What result you are getting when run this query. Blessy Baby Digitalmesh Softech pvt Ltd https://blessybaby.wordpress.com/ RohiK, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: RohiK on: 11/9/2011 [Member] Starter | Points: 25

0	the result is simple count is 1 and date gets repeated Happy Programming!! Rohi RohiK, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: PandianS on: 11/9/2011 [Member] [MVP] Silver | Points: 25

0	Rohi Can you pls try this ? Select Convert(Varchar(10),[Date],21) [Date], Count(1) [Entries] from entries Group By Convert(Varchar(10),[Date],21) Order By 1 Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions RohiK, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: RohiK on: 11/15/2011 [Member] Starter | Points: 25

0	Thanks Happy Programming!! Rohi RohiK, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts