|
To further discuss the SELECT statement,
let's look at a new example table
(for hypothetical purposes only):
|
EmployeeStatisticsTable |
| EmployeeIDNo |
Salary |
Benefits |
Position |
| 010 |
75000 |
15000 |
Manager |
| 105 |
65000 |
15000 |
Manager |
| 152 |
60000 |
15000 |
Manager |
| 215 |
60000 |
12500 |
Manager |
| 244 |
50000 |
12000 |
Staff |
| 300 |
45000 |
10000 |
Staff |
| 335 |
40000 |
10000 |
Staff |
| 400 |
32000 |
7500 |
Entry-Level |
| 441 |
28000 |
7500 |
Entry-Level |
|
