create table 'informix'.tsys_test (
    q INT not null,
    w INT not null,
    e SMALLINT not null,
    r CHAR( 20 ) not null,
    t DECIMAL( 10 , 5 ) default  0 . 000  not null,
    y DECIMAL( 16 , 3 ) not null
)
extent size  32  next size  32 
lock mode page;

delete from tsys_test;

insert into tsys_test values ( 1 , 1 , 1 ,'a', 1 . 1 , 1 . 1 );
insert into tsys_test values ( 2 , 2 , 2 ,'a', 2 . 2 , 2 . 2 );
insert into tsys_test values ( 3 , 3 , 3 ,'a', 3 . 3 , 3 . 3 );
insert into tsys_test values ( 4 , 4 , 4 ,'a', 4 . 4 , 4 . 4 );
insert into tsys_test values ( 5 , 5 , 5 ,'a', 5 . 5 , 5 . 5 );

insert into tsys_test (q,w,e,r,t,y)
  select q,w,e,'b',t,y
 from tsys_test;

select * from tsys_test
  order by  4 , 1 ;

Дает:

 1   1   1  a  1 . 10000   1 . 100 
 2   2   2  a  2 . 20000   2 . 200 
 3   3   3  a  3 . 30000   3 . 300 
 4   4   4  a  4 . 40000   4 . 400 
 5   5   5  a  5 . 50000   5 . 500 
 1   1   1  b  [b]5 . 50000   5 . 500 [/b]
 2   2   2  b  [b]5 . 50000   5 . 500 [/b]
 3   3   3  b  [b]5 . 50000   5 . 500 [/b]
 4   4   4  b  [b]5 . 50000   5 . 500 [/b]
 5   5   5  b  5 . 50000   5 . 500