MySQL Order By 06.05.10

The ORDER BY keyword is used to sort the data in a recordset.

The ORDER BY keyword sort the records in ascending order by default.

If you want to sort the records in a descending order, you can use the DESC keyword.

ORDER BY field_name ASC

ORDER BY field_name DESC

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC

Order by Two Columns

It is also possible to order by more than one column. When ordering by more than one column, the second column is only used if the values in the first column are equal:
SELECT column_name(s)
FROM table_name
ORDER BY column1, column2

Related Articles

3 Comments

  • dude , i like your template , may i know where i can find it ? it is custom made ?

    asx
    Tue 11th May, 2010
    reply
  • wah..oden lama tak melawat sini..cool ko punya theme ni..pro and minimalistic :)

    vangardx
    Sat 5th June, 2010
    reply
  • aku rasa mcm pernah jumpa theme ala-ala mcm ni…tak ingat dah…hehehe.

    mosyar
    Wed 19th January, 2011
    reply