San José State University
Department of Economics

applet-magic.com
Thayer Watkins
Silicon Valley
& Tornado Alley
USA

Standard/Structured* Query Language

*In the early days of the system there was divided preference between Standard Query Language and Structured Query Language but it did not make a whole lot of difference since most people most of the time called it by the acronym SQL. Now the overwhelming but not complete preference is for Structured Query Language.

The syntax of SQL statements is simple although inelegant. The most important type is a SELECT query, which is of the form:

Explanation

There are qualifiers which may precede the Select_List. These qualifiers are of the form

which determine whether all rows or only distinct rows will be used. The selection can also be limited to the top n or the top n percent of the rows.


HOME PAGE OF applet-magic
HOME PAGE OF Thayer Watkins