updated or deleted. The ORDER BY clause specifies how the output data — result set — should be sorted. Options Options, being the simplest constructs, are specified in association with specific keywords be sorted in a special alphabetic sequence, or case-insensitively, and the appropriate collation exists, then a COLLATE clause can be included with the ORDER BY clause when rows are being sorted on a table CREATE INDEX IDX_UPDATER ON SALARY_HISTORY (UPDATER_ID); 2. Creating an index with keys sorted in the descending order for the CHANGE_DATE column in the SALARY_HISTORY table CREATE DESCENDING

updated or deleted. The ORDER BY clause specifies how the output data — result set — should be sorted. Options Options, being the simplest constructs, are specified in association with specific keywords be sorted in a special alphabetic sequence, or case-insensitively, and the appropriate collation exists, then a COLLATE clause can be included with the ORDER BY clause when rows are being sorted on a table CREATE INDEX IDX_UPDATER ON SALARY_HISTORY (UPDATER_ID); 2. Creating an index with keys sorted in the descending order for the CHANGE_DATE column in the SALARY_HISTORY table CREATE DESCENDING

( [, ...]) | <sorted-item> | | | <sorted-item> ::= SORT () ::= [, ...]) Операторы DML 276 ::= [SORT] MERGE (<sorted-item>, <sorted-item> [, <sorted-item> ...]) ::= HASH (, [, ...])

treated as the lowest possible value for ordering purposes and sets ordered on nullable criteria are sorted accordingly. Thus: • for ascending sorts NULLs are placed at the beginning of the result set • T2.COL FROM T1, T2 ORDER BY 2 sorts on the second column of table T1, while the previous versions sorted on T2.COL. Tip This change makes it possible to specify queries like SELECT * FROM TAB ORDER BY

placed at the end of a sorted set, no matter whether the order was ascending or descending. For Firebird 1.0, that was the end of the story: NULLs would always come last in any sorted set, period. Firebird

( [, ...]) | <sorted-item> Chapter 6. Data Manipulation-Statements (DML) 275 | | | <sorted-item> ::= SORT () (, [, ...]) ::= [SORT] MERGE (<sorted-item>, <sorted-item> [, <sorted-item> ...]) ::= HASH (, [, ...])

диакритически чувствительными (accent insensitive — ai) или словарно отсортированными (dictionary-sorted - dic). Обратите внимание на то, что для новых наборов символов умолчательный порядок сортировки