SQL Statements › SELECT › ORDER BY Clause › Example

Example

This example shows an SQL query, using an ORDER BY clause, that runs against system tables (SYS authorization ID) to display keys, where TBL and FLD are correlation names.

 SELECT DISTINCT TBL.TABLE_SQLNAME,
    FLD.DBID,
    FLD.KEY_NAME,
    FLD.OCCURRENCE,
    FLD.KEY_FIELD_SEQ,
    FLD.FIELD_LENGTH,
    FLD.FIELD_UNIQUE
 FROM SYS.DIR_TABLE TBL,
            SYS.DIR_KEY_FIELD FLD
 WHERE (TBL.TABLE_NAME = FLD.TABLE_NAME)
 AND
       (TBL.TABLE_SQLNAME = 'PSN_AST' AND TBL.STATUS = 'P')
 ORDER BY FLD.DBID, FLD.KEY_NAME, FLD.KEY_FIELD_SEQ;