Learn SQL

Want to learn SQL? Our free online SQL tutorial teaches you the SQL commands you need to query your SQL database. We provide examples of SQL syntax so you can learn SQL quickly. Our SQL tutorial is a great SQL command reference.

Retrieving Multiple Columns

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.

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