sql查询 select a.Accounts,g.Score from dbo.AccountsInfo as a,QPTreasureDB.dbo.GameScoreInfo as g where a.UserID=g.UserID order by g.Score desc要怎么在上次那句sql查询结果中取前5条数据,不用存储过程,视图,麻烦会的帮忙写下 谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 5 a.Accounts,g.Score from dbo.AccountsInfo as a,QPTreasureDB.dbo.GameScoreInfo as g where a.UserID=g.UserID order by g.Score desc SELECT TOP 5 a.Accounts, g.Score FROM dbo.AccountsInfo AS a, QPTreasureDB.dbo.GameScoreInfo AS g WHERE a.UserID=g.UserID order by g.Score desc select top 5 * a.Accounts,g.Score from dbo.AccountsInfo as a,QPTreasureDB.dbo.GameScoreInfo as g where a.UserID=g.UserID order by g.Score desc 求推荐本PL/SQL的教学书 各位这个简单的SQL如何写? 多个数据库合并,急! 请教SQL语句 菜鸟求救!~~~~ 请问sql server 2000 连接服务器的问题 在线等待: 如何修复可能被破坏的数据库文件,如.Log或.Mdf文? 分组字符累加。急。。。。 如何用一条SQL语句来获得表equip中的符合条件的记录集以及统计出所含记录条数 100分,今天就给! 为什么SqlServer2005在Win7系统下安装了SP3的补丁后,依然不能使用呢?只有“配置工具”这一项。 如何提高海量数据表关联查询的效率
select top 5 a.Accounts,g.Score from dbo.AccountsInfo as a,QPTreasureDB.dbo.GameScoreInfo as g where a.UserID=g.UserID order by g.Score desc
a.Accounts
, g.Score
FROM
dbo.AccountsInfo AS a
, QPTreasureDB.dbo.GameScoreInfo AS g
WHERE a.UserID=g.UserID order by g.Score desc