Web Skills Work

{ beta }

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 WHERE Clause

The WHERE clause is optional. When it's used, it acts as a filter on the rows of the result set produced by the FROM clause

Topics include the following:

• Conditions
• Shopping Carts
• Operators
• Compound Conditions with AND and OR
• IN Conditions
• Correlated Subqueries
• EXISTS Conditions
• WHERE Clause Performance
• Wrapping Up: the WHERE Clause

 

RELATED FILES

Visit Website

Code Archive

Sample Applications & Examples

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008