Retrieving Data With Queries

Previous

Next

You can retrieve data from rows stored in one or more database tables or views with a query using the SQL SELECT statement. The SELECT statement retrieves all of or part of the column data from rows depending on the conditions that you specify in the WHERE clauses. The group of columns that are selected from a table is referred to as the SELECT list.

This section contains the following topics:

• Displaying Data Using the SELECT Statement

• Using a Column Alias to Change Headings When Selecting Data

• Restricting Data Using the WHERE Clause

• Using Regular Expressions When Selecting Data

• Sorting Data Using the ORDER BY Clause

• Displaying Data From Multiple Tables

• Using Bind Variables With the SQL Commands Page