select语句的基本语法:
SELECT [DISTINCT]<COLUMN1 [AS] 别名, COLUMN2 [AS] 别名, COLUMN3 [AS] 别名...> FROM <table_name> [WHERE <条件表达式>] [GROUP BY COLUMN1, COLUMN2, COLUMN3... | HAVING <条件表达式>] [ORDER BY < COLUMN1, COLUMN2, COLUMN3...> [ASC 或 DESC]]
2023-12-10 15:59:39
select语句的基本语法:
SELECT [DISTINCT]<COLUMN1 [AS] 别名, COLUMN2 [AS] 别名, COLUMN3 [AS] 别名...> FROM <table_name> [WHERE <条件表达式>] [GROUP BY COLUMN1, COLUMN2, COLUMN3... | HAVING <条件表达式>] [ORDER BY < COLUMN1, COLUMN2, COLUMN3...> [ASC 或 DESC]]