Billpeng Space

技术源自生活

:: :: :: ::

SQL中取出前三名的记录

Posted on 2009-09-10 15:33 billpeng 阅读(1142) 评论(0) 收藏举报

select t.* from GameScore t where id in(select top 3 id from GameScore where GameID=t.GameID order by Score desc) order by Score desc

刷新页面返回顶部