O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filtering on a Single Column

To demonstrate filtering, modify the SELECT statement to retrieve only movies with a RatingID of 1. Listing 6.7 contains the SELECT statement, and the resulting output appears in Figure 6.10.

Figure 6.10. Using the WHERE clause, you can restrict the scope of a SELECT search.
Listing 6.7. SELECT with WHERE Clause
SELECT MovieTitle, PitchText, Summary
FROM Films
WHERE RatingID=1
ORDER BY MovieTitle DESC

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required