GL SOFT INDIA
Fusion of Web, Mobile & Desktop Applications.
Showing posts with label
group by
.
Show all posts
Showing posts with label
group by
.
Show all posts
Monday, June 15, 2015
Grouping Datetime Column by Date part only.
›
SELECT DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0), COUNT(*) FROM Table1 GROUP BY DATEADD(dd,(DATEDIFF(dd,0,CRETS)),0) SELECT CAST(DATEDIFF(dd...
›
Home
View web version