Sorting records

From InterBase
Jump to: navigation, search

Go Up to Working with Tables


An index determines the display order of records in a table. In general, records appear in ascending order based on a primary index. This default behavior does not require application intervention. If you want a different sort order, however, you must specify either

  • An alternate index.
  • A list of columns on which to sort.

Specifying a different sort order requires the following steps:

  1. Determining available indexes.
  2. Specifying the alternate index or column list to use.

Topics