~drizzle-trunk/drizzle/development

Viewing changes to docs/orderby.rst

Make fixes to temporal docs
Make a few minor docs cleanups/fixes
Start using syntax-highlighting code blocks

added added

removed removed

The ORDER BY keyword is used to sort the result-set by column; by default, it sorts the records in ascending order.

SQL ORDER BY Syntax: ::

SQL ORDER BY Syntax:

.. code-block:: mysql

SELECT column_name(s)

FROM table_name

+---------+------------+----------+----------+--------+

To select all the persons from the table above, and also sort them by their last name, use the following SELECT statement: ::

To select all the persons from the table above, and also sort them by their last name, use the following SELECT statement:

.. code-block:: mysql

SELECT * FROM Persons

ORDER BY LastName;

+---------+------------+----------+----------+--------+

ORDER BY DESC can be used to reverse the order of the result set. ::

ORDER BY DESC can be used to reverse the order of the result set.

.. code-block:: mysql

SELECT * FROM Persons

ORDER BY LastName DESC;