Sort sequence used with ORDER BY and row selection

 

The examples show how rows are ordered and selected for the sort sequence used.

The values in the JOB column are in mixed case. You can see the values 'Mgr', 'MGR', and 'mgr'.

Table 1. The STAFF table

ID	NAME	DEPT	JOB	YEARS	SALARY	COMM
10	Sanders	20	Mgr	7	18357.50	0
20	Pernal	20	Sales	8	18171.25	612.45
30	Merenghi	38	MGR	5	17506.75	0
40	OBrien	38	Sales	6	18006.00	846.55
50	Hanes	15	Mgr	10	20659.80	0
60	Quigley	38	SALES	0	16808.30	650.25
70	Rothman	15	Sales	7	16502.83	1152.00
80	James	20	Clerk	0	13504.60	128.20
90	Koonitz	42	sales	6	18001.75	1386.70
100	Plotz	42	mgr	6	18352.80	0

In the following examples, the results are shown for each statement using:

• *HEX sort sequence

• Shared-weight sort sequence using the language identifier ENU

• Unique-weight sort sequence using the language identifier ENU

ENU is chosen as a language identifier by specifying either SRTSEQ(*LANGIDUNQ), or SRTSEQ(*LANGIDSHR) and LANGID(ENU), on the CRTSQLxxx, STRSQL, or RUNSQLSTM commands, or by using the SET OPTION statement.

• Sort sequence and ORDER BY
  Sort sequences affect ordering done by the ORDER BY clause.

• Sort sequence and row selection
  Sort sequences affect selection of data.

 

Parent topic:

Sort sequences and normalization in SQL