Advertisement

Abstract

Structured query language (SQL) is the lingua franca of relational databases, and a solid understanding of it is not optional. SQL is also the ultimate report writer and usually allows you to extract your data exactly in the format that you want it to print. This chapter reviews general SQL syntax and how it varies from one relational database management system (RDBMS) to another. Though most of the SQL examples in this chapter are run against the Northwind database that ships both with Microsoft SQL Server 2000 and Microsoft Access, we’ll also examine dialects of SQL particular to Microsoft Access 2000, Oracle 8, and Sybase 12.

Keywords

Statement Select Structure QuERY Language Aggregate Function Select Country Connection Object 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Carl Ganz, Jr. 2003

Authors and Affiliations

  • Carl GanzJr.

There are no affiliations available

Personalised recommendations