按分类取前三条记录

“SELECT a.*
FROM Article a
WHERE (ID IN
          (SELECT TOP 3 id
         FROM article
         WHERE classid = a.classid))
ORDER BY ClassID, ID”