• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 5. Finding the Data You Need: An Int... > Exploring the Basics of the SELECT S...

Exploring the Basics of the SELECT Statement

SELECT statements give SQL its seemingly magical powers. They do this by giving ColdFusion the capability to find a specific record or set of records based on criteria you choose.

Let's start with a sample table. In Table 5.1, I've reproduced the contents of the songs table from my database of Elvis trivia.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint