IBM® Informix® 12.10

Single-table SELECT statements

You can query a single table in a database in many ways. You can tailor a SELECT statement to perform the following actions:
  • Retrieve all or specific columns
  • Retrieve all or specific rows
  • Perform computations or other functions on the retrieved data
  • Order the data in various ways

The most basic SELECT statement contains only the two required clauses, the Projection clause and FROM.

Parent topic: Compose SELECT statements

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.