Changes

Jump to: navigation, search

Sorting Data Retrieved from a MySQL Database

No change in size, 18:07, 1 February 2016
m
Text replacement - "<google>ADSDAQBOX_FLOW</google>" to "<htmlet>adsdaqbox_flow</htmlet>"
== Sorting Data from a SELECT Statement ==
<googlehtmlet>ADSDAQBOX_FLOWadsdaqbox_flow</googlehtmlet>
In the previous chapter we look at the SQL SELECT statement and how it is used to retrieve data from a database. Typically, a SELECT statement will extract the data from a table in the order in which it was added. This, however, can change if the database table has been subjected to updates and deletions. Quite simply, there is no way to predict the exact order in which data will be retrieved. For this reason SQL provides the ''ORDER BY'' keywords which enable us to sort the data as it is retrieved by the SELECT statement.

Navigation menu