Web Skills Work | Simply SQL

SQL » Simply SQL » Chapter 7

CHAPTERS

1. An Introduction to SQL
2. An Overview of the SELECT Statement
3. The FROM Clause
4. The WHERE Clause
5. The GROUP BY Clause
6. The HAVING Clause
7. The SELECT Clause
8. The ORDER BY Clause
9. SQL Data Types
10. Relational Integrity
11. Special Structures

The SELECT Clause

The SELECT statement's single purpose is to retrieve data from our database and return it in a tabular structure. The purpose of the SELECT clause is to define the columns that will be returned in the final tabular result set.

Topics include the following:

SELECT in the Sequence of Execution
Which Columns Can Be Selected?
The Discussion Forum Application
Functions
Operators
The Dreaded, Evil Select Star
SELECT DISTINCT
Wrapping Up: the SELECT Clause

RELATED FILES

Visit Website

Code Archive

Sample Applications & Examples

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008