Informix Guide to SQL: Tutorial

Informix Guide to SQL: Tutorial
Chapter 2: Composing Simple SELECT Statements

Home Contents Index Master Index New Book

Composing Simple SELECT Statements

Introducing the SELECT Statement

Some Basic Concepts

: Privileges
: Relational Operations
: Selection and Projection
: Joining

The Forms of SELECT

Special Data Types

Single-Table SELECT Statements

Selecting All Columns and Rows

: Using the Asterisk Symbol (*)
: Reordering the Columns
: Sorting the Rows

Selecting Specific Columns

: ORDER BY and Non-English Data
: Selecting Substrings

Using the WHERE Clause

Creating a Comparison Condition

: Using Variable-Text Searches
: Using Exact Text Comparisons
: Using a Single-Character Wildcard
: MATCHES and Non-English Data
: Comparing for Special Characters

Expressions and Derived Values

: Arithmetic Expressions
: Sorting on Derived Columns

Using Functions in SELECT Statements

: Aggregate Functions
: Time Functions
: Other Functions and Keywords

Using SPL Routines in SELECT Statements

Multiple-Table SELECT Statements

Creating a Cartesian Product

Creating a Join

: Equi-Join
: Natural Join
: Multiple-Table Join

Some Query Shortcuts

: Using Aliases
: The INTO TEMP Clause

Informix Guide to SQL: Tutorial, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.