/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [CreateDate]
,[IP]
,[Method]
,[Host]
,[LocalPath]
,[URLQuery]
,[Referer]
,[UserAgent]
,[UserName]
,[SourceId]
,[System]
,[Language]
,[BrowserType]
,[UserHostName]
FROM [FPDBanner].[dbo].[StaticsLog]这是查询前100条的语句,我想查询每个月、每年的访问总数,怎么写
SELECT TOP 1000 [CreateDate]
,[IP]
,[Method]
,[Host]
,[LocalPath]
,[URLQuery]
,[Referer]
,[UserAgent]
,[UserName]
,[SourceId]
,[System]
,[Language]
,[BrowserType]
,[UserHostName]
FROM [FPDBanner].[dbo].[StaticsLog]这是查询前100条的语句,我想查询每个月、每年的访问总数,怎么写
count(1) as 访问数量
from [FPDBanner].[dbo].[StaticsLog]
group by convert(varchar(7),createdate,120)select convert(varchar(4),createdate,120) as 年,
count(1) as 访问数量
from [FPDBanner].[dbo].[StaticsLog]
group by convert(varchar(4),createdate,120)
group by convert(varchar(7),时间字段,120)--年
group by datepart(yy,时间字段)
convert(varchar(7),时间字段,120) as 月,
count(1) as 访问数量
from
[FPDBanner].[dbo].[StaticsLog]
group by
convert(varchar(7),createdate,120)select
datepart(yy,时间字段) as 年,
count(1) as 访问数量
from
[FPDBanner].[dbo].[StaticsLog]
group by
datepart(yy,时间字段)
实现没有必要用linq