用oracle语句查询出第10条到第100条数据

sqlplus远程连接一下

sqlplus /nolog

conn sys/11111 @192.168.0.39/orcl as sysdba;

alter user hr account unlock

alter user hr identified by hr

用hr的employees表做实验：

select * from (select employee_id , rownum rn from employees where rownum<=100) where rn>=10;