
Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > Using SQL > Reading data from a database

Reading data from a database

You use the SQL SELECT statement to read data from a database. The SQL statement has the following general syntax:

SELECT column_names 
FROM table_names 
[ WHERE search_condition ] 
[ GROUP BY group_expression ] [HAVING condition]
[ ORDER BY order_condition [ ASC | DESC ] ]

The statements in square brackets are optional.

Note: There are additional options to SELECT depending on your database. For a complete syntax description for SELECT, see the product documentation.

This section describes options to the SELECT statement.


Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > Using SQL > Reading data from a database

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.