select apkmd5,libraryid from apk as tem where apkid=(select top 1 apkid from apk where libraryid=tem.libraryid order by apkdate desc)
总感觉怪怪的
MS SQL 取分组后的一条数据
原文:http://www.cnblogs.com/New-world/p/4042370.html