1.
select top 10 *
from (
select 图片Id,图片名称,count(1) as num
from 表
where datediff(day,getdate(),下载时间)=0
group by 图片Id,图片名称
)t
order by num desc2. select top 10 *
from (
select 图片Id,图片名称,count(1) as num
from 表
where datediff(month,getdate(),下载时间)=0
group by 图片Id,图片名称
)t
order by num desc
select top 10 *
from (
select 图片Id,图片名称,count(1) as num
from 表
where datediff(day,getdate(),下载时间)=0
group by 图片Id,图片名称
)t
order by num desc2. select top 10 *
from (
select 图片Id,图片名称,count(1) as num
from 表
where datediff(month,getdate(),下载时间)=0
group by 图片Id,图片名称
)t
order by num desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货