Lesson 6: Retrieving Multiple Columns in SQL

You can use SQL to retrieve multiple columns.


Syntax:

Select fieldname, fieldname, fieldname
from tablename;

Explanation:

• When retrieving multiple columns, specify each field name. 
• A comma must separate field names. 
• The columns will display in the order you select them. 
• Numbers display in scientific notation.

Example:Retrieve the vendor ID, name, and current balance for each record:

1. In the SQL text box, type:

Select VendId, Name, CurrBal
from TrnVendor; 

2. Execute the command by clicking on First, the Run button located to the right of the SQL text box. The results will display on the screen.
3. Use the vertical scroll bar to move up and down the screen.
4. Click on Stop to return to the original screen

Results:
 

VendId	Name	CurrBal
TV001	Wet Off Towels	1.31300E+001
TV002	The Games All Here	4.53170E+002
TV003	BedMakers Linen	5.00000E+002
TV004	Bed Room Furniture, Inc.	3.21700E+002
TV005	Ray Block	1.00123E+003
TV006	Mosquito No Bite	9.67240E+002
TV007	Spot Out	1.60654E+003