Re: Select query order

On 2010-03-24, Krithinarayanan Ganesh Kumar  wrote:
> --000325560bde5e345c04828ac143
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi All,
>
> I am aware that Select query does not guarantee the order of the rows
> returned ( The rows are returned in whatever order the system finds fastest
> to produce).
>
> Is there any way to SELECT the rows in the same order of insertion ?

only if the records contain that information.

> The
> problem is there is no Primary Key in the table, I am having only a
> composite key. So I cannot ORDER BY pk also.

You can order by the primary key, but from your description it's unlikely 
to give insertion order.