以下是引用 刚刚在2015/7/29 9:01:11的发言: SQL类似这样:select top 10 username,Score,(select count(*) from ks_iteminfo where inputer=a.username) as num from ks_user a order by 3 desc,userid
select top 10 username,Score,(select count(*) from ks_iteminfo where inputer=a.username) as num from ks_user a where a.groupid=用户组ID order by 3 desc,userid
以下是引用 刚刚在2015/9/8 11:39:36的发言: select top 10 username,Score,(select count(*) from ks_iteminfo where inputer=a.username) as num from ks_user a where a.groupid=用户组ID order by 3 desc,userid
s elect top 10 username,Score,(s elect count(*) from ks_iteminfo where inputer=a.username and Year(AddDate)=Year(now())) as num from ks_user a where a.groupid=用户组ID order by 3 desc,userid