What is the order of query result by default ?

Hi All,

If I do : select * from myTable, is it guaranteed that the query resultset is always the order when the data is inserted into the table ?
For example :

create table myTable(col1 varchar(2) primary key)

Insert into mtTable values('x4')
Insert into mtTable values('x3')
Insert into mtTable values('x1')
Insert into mtTable values('x2')

select * from myTable // without any where condition.

then the query result is ALWAYS :
x4
x3
x1
x2

Thank you ,
xtanto Received on Wed Sep 06 2006 - 11:24:27 CDT