The order of a SQL Select statement without Order By clause
Posted
by
Yousui
on Stack Overflow
See other posts from Stack Overflow
or by Yousui
Published on 2012-04-08T16:48:08Z
Indexed on
2012/04/08
17:30 UTC
Read the original article
Hit count: 307
As I know, from the relational database theory, a select statement without an order by clause should be considered has not particular order. But actually in SQL Server and Oracle (I've tested on those 2 platforms), if I query from a table without an order by clause multiple times, I always get the results in the same order. Does this behavior can be relied on? Anyone can help to explain a little?
Thanks!
© Stack Overflow or respective owner
