Reorder the columns

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