InterBase Quick Start: Part IV - Retrieving Data

Go Up to InterBase Quick Start

The SELECT statement is very important in SQL because it enables you to retrieve the information froma database. In this part of the tutorial you practice using the SELECT statement.

Topics

• Overview of SELECT
• Removing Duplicate Rows with DISTINCT
• Using the WHERE Clause
  • Search Conditions
  • Pattern Matching
  • Testing for an Unknown Value
  • Comparing Against a Range or List of Values
  • Logical Operators
  • Controlling the Order of Evaluation
• Using Subqueries
• Using Aggregate Functions
• Grouping and Ordering Query Results
  • Using the GROUP BY Clause
  • Using the HAVING Clause
  • Ordering by an Aggregate Column
• Joining Tables
• Formatting Data

Advance To:

• Overview of SELECT