Purchase Solution

SQL Keyword SELECT

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

SQL Keyword SELECT is discussed.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.