InterBase Quick Start: Part IV - Retrieving Data

Go Up to InterBase Quick Start

The SELECT statement lies at the heart of SQL because it is how you retrieve the information you have stored. There is no use in creating and populating data structures if you cannot get the data out again in usable form. You have seen some simple forms of the SELECT statement in earlier exercises. In this part of the tutorial you get further practice with 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
• Inner Joins
• Correlation Names
• Conditions for Subqueries
• Multiple-result Subqueries
• Using ORDER BY to Arrange Rows
• Outer Joins
• Using CAST to Convert Data Types
• Using the String Operator in Search
• Converting to Uppercase