select * from (select a1.*,rownum rn from (select * from emp )a1 where rownum<=10) where rn>=6;
--是不是一定得起别名?select * from (select a1.*,rownum rn from (select * from emp )a1 where rownum<=10) where rownum>=6;
--这样不行吗?select * from (select a1.*,rownum from (select * from emp )a1 where rownum<=10) where rownum>=6;
--这样也不行?请教了!!
http://blog.csdn.net/tianlesoftware/archive/2009/12/09/4970292.aspx
呵呵~谢了~我刚刚学开始,只是看了点视频,有没什么适合Oracle新手的书推荐?