SELECT subquery.COMPANY_SEGMENT, subquery.one, subquery.two FROM ( SELECT COMPANY_SEGMENT, SUM(ABS(DEBIT)) - SUM(ABS(CREDIT)) AS one FROM INTELLIGENT_ADDITIVE_DEDUCT WHERE IS_FLAG = 0 AND ACCOUNT_SEGMENT = '2104020102' AND STAT_MON = '202307' GROUP BY COMPANY_SEGMENT UNION ALL SELECT COMPANY_SEGMENT, SUM(ABS(CREDIT)) - SUM(ABS(DEBIT)) AS two FROM INTELLIGENT_ADDITIVE_DEDUCT WHERE IS_FLAG = 0 AND ACCOUNT_SEGMENT = '2104020900' AND STAT_MON = '202307' GROUP BY COMPANY_SEGMENT ) subquery
时间: 2024-02-10 17:23:03 浏览: 27
您提供的查询语句已经进行了正确的修改。以下是您提供的查询语句的修改版本:
```sql
SELECT subquery.COMPANY_SEGMENT, subquery.one, subquery.two FROM (
SELECT
COMPANY_SEGMENT,
SUM(ABS(DEBIT)) - SUM(ABS(CREDIT)) AS one
FROM
INTELLIGENT_ADDITIVE_DEDUCT
WHERE
IS_FLAG = 0
AND ACCOUNT_SEGMENT = '2104020102'
AND STAT_MON = '202307'
GROUP BY
COMPANY_SEGMENT
UNION ALL
SELECT
COMPANY_SEGMENT,
SUM(ABS(CREDIT)) - SUM(ABS(DEBIT)) AS two
FROM
INTELLIGENT_ADDITIVE_DEDUCT
WHERE
IS_FLAG = 0
AND ACCOUNT_SEGMENT = '2104020900'
AND STAT_MON = '202307'
GROUP BY
COMPANY_SEGMENT
) AS subquery;
```
在上述查询中,我们使用了子查询,并将其命名为 "subquery"。子查询根据不同的条件分别计算了 "one" 和 "two" 列的值,并将它们的结果与 "COMPANY_SEGMENT" 列一起返回。
请注意,根据您的实际数据库结构和数据需求,您可能需要进行一些修改来适应您的环境。