Help for this page

Select Code to Download


  1. or download this
    drop table test_table;
    create table test_table (string varchar(10), num integer);
    ...
    insert into test_table(string,num) values('h',8);
    insert into test_table(string,num) values('i',9);
    insert into test_table(string,num) values('j',10);
    
  2. or download this
    SELECT string, num
    FROM test_table limit 4,3
    
  3. or download this
    select t1.string, t1.num from
    (select string, num, rownum rn from test_table) t1 
    where t1.rn between 5 and 7;