如题oracle left join 后怎么取前10条数据?求大神帮帮忙,谢谢了
直接select top10 * from a表 left join b表 on ……;
select * from (select ROWNUM as num,A.* from (select * from test) A where rownum <= 40) where num >= 20 仅供参考
where rownum <= 10