Use of the DISTINCT or UNIQUE keyword in your SELECT list, however, helps you eliminate duplicate data in your result sets.
In the example in Figure 6, four rows are returned yet only two employees are assigned to departments.
For example, you might want to ask , to be explained in subsequent installments of this series)—selected from one or more tables—that you want to display.
The FROM clause lists the table(s) from which your desired column data should be obtained.
The results format is similar to that used on the Results tab of the SQL Worksheet, as you can see by comparing Figure 5 with Figure 3.