View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 03:27 AM
K.Fawcett
 
Posts: n/a
Default insert/select question

I am doing a simple insert into a table and I would like the data to be
retrieved in the order it is inserted not by what appears to be
alphabetical order.

insert into mytbl values('c')
insert into mytbl values('b')
insert into mytbl values('a')

select * from mytbl yields

a
b
c

I would like the select to yield
c
b
a
(the order in which the data was inserted)

What is db2 doing with the ordering during insert?

Reply With Quote