Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

Sorting Query Results

When you use the SELECT statement, the results are returned to you in the order in which they appear in the table. This is usually the order in which the rows were added to the table. Since that probably isn’t the order you want, here is how to sort the query results. To sort rows, you need to add the ORDER BY clause. ORDER BY always comes after the table name; if you try to use it before, you generate a SQL error.

Now click the SQL button, enter the SQL code shown in Listing 6.4, and then click OK.

Listing 6.4. SELECT with Sorted Output

SELECT MovieTitle, PitchText, Summary FROM Films ORDER BY MovieTitle

Your output is then sorted by the MovieTitle column, as shown in Figure 6.9.

Figure 6.9. You use the ORDER BY clause ...