SELECT a, COUNT(b)
FROM 表名
GROUP BY a
WHERE b = 3;

------解决方案--------------------
SQL code
SELECT a, b FROM 表名
WHERE b = 3 and rownum<=3;

------解决方案--------------------
问题么说明白啊，把你表里面的数据贴出来瞅瞅啊