Home | Previous Page | Next Page

Composing SELECT Statements

In This Chapter

Introducing the SELECT Statement

Output from SELECT Statements

Output from Large Object Data Types

Output from User-Defined Data Types

Output in Non-Default Code Sets

Some Basic Concepts

Relational Operations

Selection and Projection

Single-Table SELECT Statements

Using the Asterisk Symbol (*)

Reordering the Columns

Using the ORDER BY Clause to Sort the Rows

Ascending Order

Descending Order

Sorting on Multiple Columns

Selecting Specific Columns

Selecting Substrings

ORDER BY and Non-English Data

Using the WHERE Clause

Creating a Comparison Condition

Specifying A Range of Rows

Excluding a Range of Rows

Using a WHERE Clause to Find a Subset of Values

Identifying NULL Values

Forming Compound Conditions

Using Exact-Text Comparisons

Using Variable-Text Searches

Using a Single-Character Wildcard

MATCHES and Non-Default Locales

Protecting Special Characters

Using Subscripting in a WHERE Clause

Using a FIRST Clause to Select Specific Rows

FIRST Clause Without an ORDER BY Clause

FIRST Clause with an ORDER BY Clause

Expressions and Derived Values

Arithmetic Expressions

CASE Expressions

Sorting on Derived Columns

Using Rowid Values In SELECT Statements

Multiple-Table SELECT Statements

Creating a Cartesian Product

Creating a Join

Cross Join (IDS)

Multiple-Table Join

Some Query Shortcuts

The INTO TEMP Clause

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]