第4章 例题(子查询和group by子句)（Chapter fourth examples (sub queries and group by clause)）.docVIP

第4章 例题(子查询和group by子句)（Chapter fourth examples (sub queries and group by clause)） The select statement syntax: Select [distinct] 1 field, 2 field, 3 field, n field | * from... [where query expression] [grop by group field] [having packet data for each condition increased [order by [asc|desc]] | sort field sort expression Select the column 4.2.1 1, select the specified column In 4.5 cases Use xscj; Select name, professional name, total credits from xs; 2, the definition of a column alias 4.6 definition column alias (defined alias only this kind of format in Mysql) The select code as number, the