Neoview SQL Reference Manual (R2.3)

2. Drop rows with unequal job codes.
JOB TableEMPLOYEE Table
JOBDESCJOBCODESALARYJOBCODE ...EMPNUM ...
MANAGER1001755001001
. . .. . .. . .. . .. . .
SALESREP3003200030075
. . .. . .. . .. . .. . .
SECRETARY90028000900178
. . .. . .. . .. . .. . .
ENGINEER42033000420207
. . .. . .. . .. . .. . .
SALESREP30039500300568
3. Drop rows with job codes not equal to 900, 300, or 420.
JOB TableEMPLOYEE Table
JOBDESCJOBCODESALARYJOBCODE ...EMPNUM ...
SALESREP3003200030075
. . .. . .. . .. . .. . .
SECRETARY90028000900178
. . .. . .. . .. . .. . .
ENGINEER42033000420207
. . .. . .. . .. . .. . .
SALESREP30039500300568
4. Process the select list, leaving only four columns.
SALARYLAST_NAMEFIRST_NAMEJOBDESC
32000WALKERTIMSALESREP
. . .. . .. . .. . .
28000CHOUJOHNSECRETARY
. . .. . .. . .. . .
33000FOLEYMARKENGINEER
. . .. . .. . .. . .
39500CRINERJESSICASALESREP
The final result is shown in the output:
JOBDESC FIRST_NAME LAST_NAME SALARY
------------ ------------ --------------- -----------
SALESREP TIM WALKER 32000.00
...
SELECT Statement 161