O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Book III

SQL Queries

9780470929964-pp0301.eps

Contents at a Glance

Chapter 1: Values, Variables, Functions, and Expressions

Entering Data Values

Working with Functions

Using Expressions

Chapter 2: SELECT Statements and Modifying Clauses

Finding Needles in Haystacks with the SELECT Statement

Modifying Clauses

Tuning Queries

Chapter 3: Querying Multiple Tables with Subqueries

What Is a Subquery?

What Subqueries Do

Using Subqueries in INSERT, DELETE, and UPDATE Statements

Tuning Considerations for Statements Containing Nested Queries

Tuning Correlated Subqueries

Chapter 4: Querying Multiple Tables with Relational Operators

UNION

INTERSECT

EXCEPT

JOINS

ON versus WHERE

Join Conditions and Clustering Indexes

Chapter 5: Cursors

Declaring a Cursor

Opening a Cursor

Operating on a Single Row

Closing a Cursor

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required