Share
Explore BrainMass

SQL Keyword SELECT

Use the attached tables (General Sales Database) to answer A. and B.

A. Explain the use of the of SQL keyword SELECT. Include an example based on the CUSTOMER table in the General Sales database.

B. Explain the use of the GROUP BY keyword. Include an example based on the CUSTOMER table from the General Sales database.

Attachments

Solution Preview

The SELECT statement is used to pick data from a table and the result is stored in a result table. For example,
SELECT CustNo, CustName
FROM ...

Solution Summary

SQL Keyword SELECT is discussed.

$2.19