SQL/MP Query Guide

Retrieving Data: How to Write Queries
HP NonStop SQL/MP Query Guide—524488-003
1-3
Selecting Columns
Selecting Columns
Selecting columns from a table is known as projection. The query in Figure 1-1 selects
three columns: FIRST_NAME, LAST_NAME, and DEPTNUM.
Figure 1-1. Selecting Columns From a Table (Projection)
EMPNUM
FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
ROGER
JERRY
JESSICA
GREEN
HOWARD
CRINER
9000
1000
3500
100
100
300
175500.00
137000.00
39500.00
1
23
568
EMPLOYEE
SELECT FIRST_NAME, LAST_NAME, DEPTNUM
FROM EMPLOYEE
FIRST_NAME LAST_NAME DEPTNUM
ROGER
JERRY
JESSICA
GREEN
HOWARD
CRINER
9000
1000
3500
VST0101.vsd
•••
•••
•••
•••
•••
•••
••• •••
•••