SELECT Statement - OUSELECT语句中-欧.docVIP

Microsoft SQL Syntax Data Manipulation Language SELECT Statement 2 ALL, DISTINCT, DISTINCTROW, TOP Predicates 3 FROM Clause 6 GROUP BY Clause 6 HAVING Clause 8 IN Clause 9 INNER JOIN Operation 10 LEFT JOIN, RIGHT JOIN Operations 12 ORDER BY Clause 14 SELECT...INTO Statement 15 UNION Operation 17 WHERE Clause 18 WITH OWNERACCESS OPTION Declaration 20 SQL Aggregate Functions 20 Count Function 21 First, Last Functions 22 Calculating Fields in SQL Functions 23 Min, Max Functions 23 StDev, StDevP Functions 24 Sum Function 25 Var, VarP Functions 26 INSERT INTO Statement 26 DROP Statement 28 DELETE Statement 29 UPDATE Statement 29 SELECT Statement Instructs the Microsoft Jet database engine to return information from the database as a set of records. Syntax SELECT [predicate] { * | table.* | [table.]field1 [AS alias1] [, [table.]field2 [AS alias2] [, ...]]}FROM tableexpression [, ...] [IN externaldatabase][WHERE... ][GROUP BY... ][HAVING... ][ORDER BY... ][WITH OWNERACCESS OPTION] The SELECT statement has these parts: Part Description predicate One of the following predicates: ALL, DISTINCT, DISTINCTROW, or TOP. You use the predicate to restrict the number of records returned. If none is specified, the default is ALL. * Specifies that all fields from the specified table or tables are selected. table The name of the table containing the fields from which records are selected. field1, field2 The names of the fields containing the data you want to retrieve. If you include more than one field, they are retrieved in the order listed. alias1, alias2 The names to use as column headers instead of the original column names in table. tableexpression The name of the table or tables containing the data you want to retrieve. externaldatabase The name of the database containing the tables in tableexpression if they are not in the current database. Remarks To perform this operation, the Microsoft? Jet database engine searches the specified table or tables, extracts the chosen