Billpeng Space

技术源自生活

:: :: :: ::

SQL中取出前三名的记录

摘要： 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 阅读全文

posted @ 2009-09-10 15:33 billpeng 阅读(1110) 评论(0) 推荐(0) 编辑