数据查询.pptVIP

数据查询 单表查询 语法格式： SELECT [ ALL | DISTINCT ] [ TOP n [ PERCENT ] ] { *?| { table_name | view_name | table_alias }.* ?| { column_name | expression [[AS] column_alias] | column_alias = expression}?[ ,...n ] [ INTO new_table ] [FROM table_source] [WHERE search_condition] [GROUP BY group_by_expression] [HAVING search_condition] [ORDER BY order_expression [ASC | DESC]] 单表查询 ----1.输出字段 语法格式： SELECT [ ALL | DISTINCT ] [ TOP n [ PERCENT ] ] { *?| { table_name | view_name | table_alias }.* ?| { column_name | expression [[AS] column_alias] | column_alias =