Hi,
SQL standard does not define the order of the duplicate rows and sqlite
does not either. I would really not depend on a thing like this, even if
the rows are in fact retrieved in the same order they were inserted
(some DB systems I know of do this). If you need the rows retrieve Rows
in a
Hi,
is the order, in which rows with duplicate keys are retrieved, specified?
For example: A table with two columns - the first is a Index. If I
INSERT in the following order:
C1 C2
-
3 1
1 1
1 2
1 1
1 3
2 1
If I now do a "SELECT * FROM Table ORDER BY C1;", is it guranteed that
the
2 matches
Mail list logo