求一分组SQL语句??急
表a

cUrlNo vcUrl vcUrlTitle cCateNo
0101 www.a.com a 01
0102 www.b.com b 02
0103 www.c.com c 01

按照cCateNo查找出前十条记录

[解决办法]
--try

select * from T as tmp
where (select count(*) from T where cCateNo=tmp.cCateNo and cUrlNo <tmp.cUrlNo) <10