[SQL] ORDER BY question

[Christian Paul Cosinas]

Hi,

For example I have a table like this

ID      Name
1       A
1       B
2       C
2       D

And I have a Query like this:
SELECT * FROM table ORDER BY ID.

Would my result always give me the same order or is there may be a possible
different result?

For example?

1       B
1       A
2       D
2       C


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match