Article Preview
Buy Now
FEATURE
Dealing with Databases
Learning SQL Part 2
Issue: 2.6 (July/August 2004)
Author: Jonathan Johnson
Author Bio: Jonathan Johnson is a Tester for REAL Software. He has done database contract work for two years, and continues to work with databases almost every day.
Article Description: No description available.
Article Length (in bytes): 9,483
Starting Page Number: 27
Article Number: 2612
Related Link(s): None
Excerpt of article text...
In the previous installment, we learned the basics of the SQL SELECT statement. However, there are more features to it. Aggregate functions can do math for you and ORDER BY and GROUP BY statements provide helpful data organization, and queries can span multiple tables to help link related tables together. We'll also learn how to put data into the database with the INSERT statement and change it with the UPDATE statement.
For the examples in this tutorial, we'll assume two tables: Customers and Orders. The databases will be related so that each order has a customer number.
Aggregate Functions
...End of Excerpt. Please purchase the magazine to read the full article.