Query Fundamentals

A query is a request for data stored in Microsoft® SQL Server™. A query can be issued using several forms:

Although queries have various ways of interacting with a user, they all accomplish the same task: They present the result set of a SELECT statement to the user. Even if the user never specifies a SELECT statement, as is usually the case with graphical tools such as MS Query, the client software transforms each user query into a SELECT statement that is sent to SQL Server.

The SELECT statement retrieves data from SQL Server and presents it back to the user in one or more result sets. A result set is a tabular arrangement of the data from the SELECT. Like an SQL table, the result set comprises columns and rows.

The full syntax of the SELECT statement is complex, but most SELECT statements describe four primary properties of a result set:

This SELECT statement finds the product ID, name, and unit price of any products whose unit price exceeds $40:

SELECT ProductID, ProductName, UnitPrice

FROM Products

WHERE UnitPrice > $40

ORDER BY UnitPrice ASC

  

The column names listed after the SELECT keyword (ProductID, ProductName, and UnitPrice) form the select list. This specifies that the result set has three columns, and each column has the name, data type, and size of the associated column in the Products table. Because the FROM clause specifies only one base table, all column names in the SELECT statement refer to columns in that table.

The FROM clause lists the single table, Products, from which the data is to be retrieved.

The WHERE clause specifies that the only rows in Products that qualify for this SELECT are those in which the value of the UnitPrice column exceeds $40.

The ORDER BY clause specifies that the result set is to be sorted in ascending sequence based on the value in the UnitPrice column.

See Also
FROM SELECT
Distributed Queries WHERE

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.