Retrieving a Single Column
You can use SQL to retrieve a single column of data.
Syntax:
Select fieldname
from tablename;
Explanation:
- Instead of an asterisk, the name of the field is specified in the Select clause.
- Field names are not case-sensitive. You can type field names in uppercase or lowercase letters.
Retrieve the vendor name from each record:
- In the SQL text box, type:
Select Name
from TrnVendor;
- Click on First, the Run button located to the right of the SQL text box. The results will display on the screen.
- Use the vertical scroll bar to move up and down the screen.
- Click on Stop to return to the original screen.
Results:
| Name |
| Wet Off Towels |
| The Games All Here |
| BedMakers Linen |
| Bed Room Furniture, Inc. |
| Ray Block |
| Mosquito No Bite |
| Spot Out |
| Big Tree Landscaping |
| Hit the Deck |
| The Soda Factory |
| The Freelance |
| Paper People |
| Softer Software |
| Counter Productive |
| No Waste Disposal |
| Music Maker |
| Food Four |
| Computer Bytes |
| Bayshore Consulting |
| BayCon Group |
| Cooperative Operatives |
| Legal Lookup |
| World Wide Learning U |
| Enterprise Transport |
| Against the Tide |
| Clampett Oil |
| Narrow Nest |
| Distant Horizons |
| Paltry Play |
| Make Shift Tilts |
| Table of Contents |
