SELECT bc.id as businessCompanyId, bc.company_name as businessCompanyName, any_value(su.`user_name`) as businessUser, bcff.type as fileType, fcl.clean_type as fileType, -- CASE sex WHEN ‘1’ THEN ‘男’ WHEN ‘2’ THEN ‘女’ ELSE ‘其他’ END CASE fcl.clean_type when 0 then count(fcl.id) as goodsCodeErrorNum when 1 then count(fcl.id) as hospitalNameErrorNum when 2 then count(fcl.id) as orderTypeErrorNum END FROM business_company bc INNER JOIN business_company_flow_file bcff ON bcff.business_company_id = bc.id INNER JOIN business_flow_detail bfd ON bcff.id = bfd.flow_file_id INNER JOIN flow_clean_log fcl ON fcl.business_flow_detail_id = bfd.id LEFT JOIN sys_user su ON su.user_id = bc.user_id GROUP BY bc.id, bcff.type, fcl.clean_type
时间: 2024-02-14 16:35:17 浏览: 23
这是一条 SQL 查询语句,它的功能是从多个表中查询数据并进行聚合。具体来说,它查询了 business_company 表、business_company_flow_file 表、business_flow_detail 表、flow_clean_log 表和 sys_user 表,然后根据 business_company 的 id、business_company_flow_file 的 type 和 flow_clean_log 的 clean_type 进行分组,最后对每组数据进行统计计数。其中,any_value 函数用于返回一组值中的任意一个值,CASE 语句用于根据条件返回不同的值。
相关问题
select tb_user.id, tb_user.user_name as userName, tb_user.user_pwd as userPwd, tb_user.user_gender as userGender, tb_role.role_name as roleName, from tb_user left join tb_role on tb_user.rid=tb_role.id;纠错
您的SQL查询语句有一个错误:在SELECT语句中,最后一个字段后面有一个逗号,应该将其删除。正确的查询语句如下:
```
SELECT tb_user.id, tb_user.user_name as userName, tb_user.user_pwd as userPwd, tb_user.user_gender as userGender, tb_role.role_name as roleName
FROM tb_user
LEFT JOIN tb_role
ON tb_user.rid=tb_role.id;
```
该查询语句将从`tb_user`表中选取`id`、`user_name`、`user_pwd`、`user_gender`四个字段,以及从`tb_role`表中选取`role_name`字段。使用LEFT JOIN将这两个表连接起来,连接条件是`tb_user.rid=tb_role.id`。
select tsatrackphonestage.id ,tsatrackphonestage.title as name from t_sa_track_phone_stage tsatrackphonestage 查询返回字符串
您可以使用以下 SQL 语句来查询并返回字符串:
```
SELECT CAST(tsatrackphonestage.id AS varchar) + ' ' + tsatrackphonestage.title AS name
FROM t_sa_track_phone_stage tsatrackphonestage
```
这将返回一个包含 id 和 title 的字符串,中间用空格隔开,类似于 "1 Some Title"。请注意,字符串连接运算符在不同的数据库中可能会有所不同。