declare @lastweek datetimedeclare @now datetimeset @now = getdate()set @lastweek = dateadd(day,-7,@now)SELECt URLX, COUNT(URLx) AS CountFROM ExternalHitsWHERe datex BETWEEN @lastweek AND @nowGROUP BY URLxORDER BY Count DESC;
declare @lastweek datetimedeclare @now datetimeset @now = getdate()set @lastweek = dateadd(day,-7,@now)SELECt URLX, COUNT(URLx) AS CountFROM ExternalHitsWHERe datex BETWEEN @lastweek AND @nowGROUP BY URLxORDER BY Count DESC;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
