drop table if exists tab1;
create table tab1(col1 integer);
create index idx1 on tab1(col1);
insert into tab1 values (1);
insert into tab1 values (2);
begin work;
insert into tab1 values (3);
select * from tab1;

       col1
          1
          2
          3

insert into tab1 values (5);
select first 10 * from tab1 order by 1 desc;

       col1
          5
          5
          5
          5
          5
          5
          5
          5
          5
          5

create table tab1(col1 integer) lock mode row;