SQL Tutorial - HP Web PrintSmart Plus! 2

Introduction to Structured Query LanguageVersion 4.75 This page is a introductory tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this isthe first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such asOracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows usersto define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is"ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. It isrecommended that you print this page, so that you can easily refer back to previous examples. Also, you may be interested in joining the new SQL Club on Yahoo!, where you can read or enter messages in a SQL forum.  Table of ContentsBasics of the SELECT StatementConditional SelectionRelational OperatorsCompound ConditionsIN & BETWEENUsing LIKEJoinsKeysPerforming a JoinEliminating DuplicatesAliases & In/SubqueriesAggregate FunctionsViewsCreating New TablesAltering TablesAdding DataDeleting DataUpdating DataIndexesGROUP BY & HAVINGMore SubqueriesEXISTS & ALLUNION & Outer JoinsEmbedded SQLCommon SQL QuestionsNonstandard SQLSyntax ...