Tutorial: Selecting Specific Columns of a Table

This tutorial shows how to select only the columns FIRST_NAME, LAST_NAME, and DEPARTMENT_ID of the EMPLOYEES table.

To select only FIRST_NAME, LAST_NAME, and DEPARTMENT_ID:

1. Click the icon SQL Worksheet.

   The SQL Worksheet pane appears.

2. In the field under "Enter SQL Statement:", enter this query:

   SELECT FIRST_NAME, LAST_NAME, DEPARTMENT_ID
   FROM EMPLOYEES;
   

3. Click the icon Execute Statement.

   The query runs.

4. Click the tab Results.

   The Results pane appears, showing the results of the query, which are similar to:

   FIRST_NAME           LAST_NAME                 DEPARTMENT_ID
   -------------------- ------------------------- -------------
   Donald               OConnell                             50
   Douglas              Grant                                50
   Jennifer             Whalen                               10
   Michael              Hartstein                            20
   Pat                  Fay                                  20
   Susan                Mavris                               40
   Hermann              Baer                                 70
   Shelley              Higgins                             110
   William              Gietz                               110
   Steven               King                                 90
   Neena                Kochhar                              90
    
   FIRST_NAME           LAST_NAME                 DEPARTMENT_ID
   -------------------- ------------------------- -------------
   Lex                  De Haan                              90
   ...
   Kevin                Feeney                               50
    
   107 rows selected.