Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
 ALLBASE/SQL Reference Manual: HP 9000 Computer Systems

Chapter 3 SQL Queries
» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Table of Contents

Using the SELECT Statement
Simple Queries
Complex Queries
UNION Queries
Using Character Constants with UNION
Subqueries
Special Predicates
Quantified Predicate
IN Predicate
EXISTS Predicate
Correlated Versus Noncorrelated Subqueries
Outer Joins
Using GENPLAN to Display the Access Plan
Generating a Plan
Displaying a Query Access Plan
Interpreting a Display
Updatability of Queries

This chapter describes SQL queries, through which you access the data in database tables. The following sections are presented:

  • Using the SELECT Statement

  • Simple Queries

  • Complex Queries

  • Using GENPLAN to Display the Access Plan

  • Updatability of Queries

The other kinds of data manipulation, using the INSERT, UPDATE, and DELETE statements, were presented in the chapter "Using ALLBASE/SQL."



Understanding the System Catalog
  		 


Using the SELECT Statement  
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.