The following query shows how you can change the order in which
the columns are listed by changing their order in your projection
list. Figure 1: Query
SELECT manu_name, manu_code, lead_time FROM manufact;
The query result includes the same columns as the
previous query result, but because the columns are specified in a
different order, the display is also different. Figure 2: Query result
manu_name manu_code lead_time
Smith SMT 3
Anza ANZ 5
Norge NRG 7
Husky HSK 5
Hero HRO 4
Shimara SHM 30
Karsten KAR 21
Nikolus NKL 8
ProCycle PRC 9