询问一个数据库查询语句写法 select top 10 userid, count(1) as 访问次数from recordgroup by useridorder by 访问次数 desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT TOP 10 * FROM (SELECT COUNT(login_id)访问次数,userID FROM record GROUP BY userID )ORDER BY 访问次数 DESC SELECT TOP 10 * FROM (SELECT COUNT(login_id)访问次数,userID FROM record GROUP BY userID )ORDER BY 访问次数 DESC select top 10 userID ,count(login_id) as LoginNum from recordgroup by userID order by LoginNum 忘了 group by...果然是我太嫩了 谢谢各位 sql问题 mysql sql语句 [高手请进]求助openrowset访问access的问题 如何删除数据库中所有的用户表?? MSSQL表问题,请指教 远程登录问题 如何查看摸个数据库的日志 SQL Server服务管理器不能启动 如何删除用户分区 企业版sqlserver的怪现像 写个存储过程,给个思路 sql能实现这种功能吗?
SELECT COUNT(login_id)访问次数,userID FROM record GROUP BY userID )ORDER BY 访问次数 DESC
SELECT COUNT(login_id)访问次数,userID FROM record GROUP BY userID )ORDER BY 访问次数 DESC
select top 10 userID ,count(login_id) as LoginNum from record
group by userID order by LoginNum
果然是我太嫩了 谢谢各位