friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.sqlp_5.4.0.1/rbafyorderby2.htm

343 lines
24 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
2024-04-02 14:02:31 +00:00
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="security" content="public" />
<meta name="Robots" content="index,follow" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta name="DC.Type" content="reference" />
<meta name="DC.Title" content="Sort sequence and ORDER BY" />
<meta name="abstract" content="See how sort sequences work with ORDER BY." />
<meta name="description" content="See how sort sequences work with ORDER BY." />
<meta name="DC.subject" content="sort sequence, using with ORDER BY, ORDER BY, with sort sequence, examples, ORDER BY" />
<meta name="keywords" content="sort sequence, using with ORDER BY, ORDER BY, with sort sequence, examples, ORDER BY" />
<meta name="DC.Relation" scheme="URI" content="rbafyssorder.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rbafyorderby2" />
<meta name="DC.Language" content="en-us" />
<!-- All rights reserved. Licensed Materials Property of IBM -->
<!-- US Government Users Restricted Rights -->
<!-- Use, duplication or disclosure restricted by -->
<!-- GSA ADP Schedule Contract with IBM Corp. -->
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
<link rel="stylesheet" type="text/css" href="./ic.css" />
<title>Sort sequence and ORDER BY</title>
</head>
<body id="rbafyorderby2"><a name="rbafyorderby2"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Sort sequence and ORDER BY</h1>
<div><p>See how sort sequences work with ORDER BY.</p>
<div class="section"><div class="p">The following SQL statement causes the result table to be sorted
using the values in the JOB column: <pre><strong>SELECT</strong> * <strong>FROM</strong> STAFF <strong>ORDER BY</strong> JOB</pre>
</div>
</div>
<div class="section"><p>The following table shows the result using a *HEX sort sequence.
The rows are sorted based on the EBCDIC value in the JOB column. In this case,
all lowercase letters sort before the uppercase letters.</p>
</div>
<div class="tablenoborder"><a name="rbafyorderby2__nlsstb1"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafyorderby2__nlsstb1" width="100%" frame="hsides" border="1" rules="all"><caption>Table 1. Result
of using the *HEX sort sequence</caption><thead align="left"><tr><th align="left" valign="bottom" width="14.25925925925926%" id="d0e56">ID</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e58">NAME</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e60">DEPT</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e62">JOB</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e64">YEARS</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e66">SALARY</th>
<th align="left" valign="bottom" width="14.444444444444443%" id="d0e68">COMM</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">100</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Plotz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">18352.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">90</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Koonitz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">18001.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">1386.70</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">80</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">James</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Clerk</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">13504.60</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">128.20</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Sanders</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">18357.50</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">50</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Hanes</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">20659.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">30</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Merenghi</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">MGR</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">5</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">17506.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Pernal</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">8</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">18171.25</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">612.45</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">40</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">OBrien</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">18006.00</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">846.55</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">70</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Rothman</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">16502.83</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">1152.00</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e56 ">60</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e58 ">Quigley</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e60 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e62 ">SALES</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e64 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e66 ">16808.30</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e68 ">650.25</td>
</tr>
</tbody>
</table>
</div>
<div class="section"><p>The following table shows how sorting is done for a unique-weight
sort sequence. After the sort sequence is applied to the values in the JOB
column, the rows are sorted. Notice that after the sort, lowercase letters
are before the same uppercase letters, and the values 'mgr', 'Mgr', and 'MGR'
are adjacent to each other.</p>
</div>
<div class="tablenoborder"><a name="rbafyorderby2__nlsstb2"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafyorderby2__nlsstb2" width="100%" frame="hsides" border="1" rules="all"><caption>Table 2. Result
of using the unique-weight sort sequence for the ENU language identifier</caption><thead align="left"><tr><th align="left" valign="bottom" width="14.25925925925926%" id="d0e237">ID</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e239">NAME</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e241">DEPT</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e243">JOB</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e245">YEARS</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e247">SALARY</th>
<th align="left" valign="bottom" width="14.444444444444443%" id="d0e249">COMM</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">80</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">James</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Clerk</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">13504.60</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">128.20</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">100</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Plotz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">18352.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Sanders</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">18357.50</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">50</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Hanes</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">20659.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">30</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Merenghi</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">MGR</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">5</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">17506.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">90</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Koonitz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">18001.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">1386.70</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Pernal</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">8</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">18171.25</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">612.45</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">40</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">OBrien</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">18006.00</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">846.55</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">70</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Rothman</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">16502.83</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">1152.00</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e237 ">60</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e239 ">Quigley</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e241 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e243 ">SALES</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e245 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e247 ">16808.30</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e249 ">650.25</td>
</tr>
</tbody>
</table>
</div>
<div class="section"><p>The following table shows how sorting is done for a shared-weight
sort sequence. After the sort sequence is applied to the values in the JOB
column, the rows are sorted. For the sort comparison, each lowercase letter
is treated the same as the corresponding uppercase letter. In this table,
notice that all the values 'MGR', 'mgr' and 'Mgr' are mixed together.</p>
</div>
<div class="tablenoborder"><a name="rbafyorderby2__nlsstb3"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafyorderby2__nlsstb3" width="100%" frame="hsides" border="1" rules="all"><caption>Table 3. Result
of using the shared-weight sort sequence for the ENU language identifier</caption><thead align="left"><tr><th align="left" valign="bottom" width="14.25925925925926%" id="d0e418">ID</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e420">NAME</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e422">DEPT</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e424">JOB</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e426">YEARS</th>
<th align="left" valign="bottom" width="14.25925925925926%" id="d0e428">SALARY</th>
<th align="left" valign="bottom" width="14.444444444444443%" id="d0e430">COMM</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">80</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">James</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Clerk</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">13504.60</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">128.20</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Sanders</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">18357.50</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">30</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Merenghi</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">MGR</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">5</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">17506.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">50</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Hanes</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">10</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">20659.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">100</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Plotz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">mgr</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">18352.80</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Pernal</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">20</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">8</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">18171.25</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">612.45</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">40</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">OBrien</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">18006.00</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">846.55</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">60</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Quigley</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">38</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">SALES</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">0</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">16808.30</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">650.25</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">70</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Rothman</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">15</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">Sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">7</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">16502.83</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">1152.00</td>
</tr>
<tr><td align="left" valign="top" width="14.25925925925926%" headers="d0e418 ">90</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e420 ">Koonitz</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e422 ">42</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e424 ">sales</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e426 ">6</td>
<td align="left" valign="top" width="14.25925925925926%" headers="d0e428 ">18001.75</td>
<td align="left" valign="top" width="14.444444444444443%" headers="d0e430 ">1386.70</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafyssorder.htm" title="To see how to use a sort sequence, run the examples against the STAFF table shown in this topic.">Sort sequence used with ORDER BY and row selection</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink