select *
from (select sale_code_sid, count(*)
from sale_class
having count(sale_code_sid) = 14
group by sale_code_sid)
where rownum < 11;
from (select sale_code_sid, count(*)
from sale_class
having count(sale_code_sid) = 14
group by sale_code_sid)
where rownum < 11;