~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/orderby.rst

  • Committer: Marisa Plumb
  • Date: 2011-03-11 15:54:41 UTC
  • mto: (2235.2.4 build)
  • mto: This revision was merged to the branch mainline in revision 2237.
  • Revision ID: marisa.plumb@gmail.com-20110311155441-1qamt9gp8v9nxiht
current time function fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
44
44
| 2       | Roberts    | Teri     |21 Brown  | Chicago|
45
45
+---------+------------+----------+----------+--------+
46
46
 
 
47
Without using "ORDERBY" in the following query, the result-set will be non-deterministic, and could returned matching rows in a different order for each query. 
 
48
 
47
49
ORDER BY DESC can be used to reverse the order of the result set.
48
50
 
49
51
.. code-block:: mysql
51
53
        SELECT * FROM Persons
52
54
        ORDER BY LastName DESC;
53
55
 
54
 
.. todo::
55
 
 
56
 
   add something about SELECT * without ORDER BY being non-deterministic
57
56
 
58
57
.. todo::
59
58