DML语句
更新时间：2025-08-21
百度流式计算QUERY语句完全兼容SPARK/FLINK SQL查询语句，根据创建作业时指定的引擎类型来决定使用哪种引擎的查询语句。
INSERT INTO语句
语法
Plain Text
1INSERT INTO tableName
2QUERY语句- 同一个作业中，仅支持一个DML语句。
- 不支持单独的QUERY语句，需要在INSERT INTO内操作查询。
示例
Plain Text
1INSERT INTO Orders
2SELECT * FROM Orders WHERE units > 1000;QUERY语句
语法
Plain Text
1SELECT语句 [ ORDER BY expression ( ASC | DESC ) ]
2| QUERY语句 （ INTERSECT | UNION | EXCEPT | SETMINUS ) [ ALL ] QUERY语句示例一
Plain Text
1SELECT a,b as B FROM tableName
2UNION
3SELECT a,b as B FROM otherTableName
4ORDER BY a DESCSELECT语句
语法
Plain Text
1SELECT [ distinct ] { * | projectItem [ , projectItem ] }
2FROM tableExpression
3[ WHERE booleanExpression ]
4[ GROUP BY { groupItem [, groupItem ]* } ]
5[ HAVING booleanExpression ]示例一
Plain Text
1SELECT * FROM tableName;示例二
Plain Text
1SELECT a,b as B FROM tableName;WHERE语句
语法
Plain Text
1SELECT { * | projectItem [, projectItem ]* } FROM tableExpression [ WHERE booleanExpression ]说明
WHERE语句通过添加条件过滤SQL语句的结果集，多个条件之间可以用AND、OR关联。
示例
Plain Text
1SELECT * FROM Orders WHERE units > 1000;GROUP BY语句
语法
Plain Text
1SELECT [ ALL | DISTINCT ] { * | projectItem [, projectItem ]* } FROM tableExpression [ WHERE booleanExpression ] [ GROUP BY { groupItem [, groupItem ]* } ]说明
GROUP BY 语句用于结合聚合函数，根据一个或多个列对结果集进行分组。
示例
Plain Text
1SELECT Customer,SUM(OrderPrice) FROM Orders
2[GROUP BY Customer]HAVING语句
语法
Plain Text
1 SELECT [ ALL | DISTINCT ]{ * | projectItem [, projectItem ]* }
2 FROM tableExpression
3 [ WHERE booleanExpression ]
4 [ GROUP BY { groupItem [, groupItem ]* } ]
5 [ HAVING booleanExpression ];说明
HAVING语句一般与GROUP BY语句一起使用，用于过滤聚合函数的结果。
示例
Plain Text
1SELECT Customer,SUM(OrderPrice) FROM Orders
2WHERE Customer='Bush' OR Customer='Adams'
3GROUP BY Customer
4HAVING SUM(OrderPrice)>1500ORDER BY语句
语法
Plain Text
1 SELECT [ ALL | DISTINCT ]{ * | projectItem [, projectItem ]* }
2 FROM tableExpression
3 [ ORDER BY expression ( [ ASC ] | DESC ) ];说明
ORDER BY 语句用于根据指定的列对结果集进行排序,默认按照升序对记录进行排序。使用 DESC 关键字对记录进行降序排列。
示例
SELECT Company, OrderNumber FROM Orders ORDER BY Company