SELECT top 5 a.[CooID], count(a.ID)
as Num,b.SiteName,b.SiteURL
FROM [wmsPicInfo] as a INNER JOIN wmswapsiteinfo AS b on a.[CooID] = b.[UID]
group by a.CooID,b.SiteName,b.SiteURL order by num desc
...全文
20210打赏收藏
这个SQL语句还能怎么优化?
SELECT top 5 a.[CooID], count(a.ID) as Num,b.SiteName,b.SiteURL FROM [wmsPicInfo] as a INNER JOIN wmswapsiteinfo AS b on a.[CooID] = b.[UID] group by a.CooID,b.SiteName,b.SiteURL order by num desc