SELECT COMPANY_SEGMENT,one,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 ORDER 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 ORDER BY COMPANY_SEGMENT )
时间: 2024-04-07 07:33:46 浏览: 20
根据您提供的SQL查询语句,您似乎想要从表 INTELLIGENT_ADDITIVE_DEDUCT 中查询两个不同的条件,并将它们的结果合并在一起。以下是您提供的查询语句的修改版本:
```sql
SELECT COMPANY_SEGMENT, one, 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;
```
在上述查询中,我们将两个子查询使用 UNION ALL 进行组合,并使用别名 "subquery" 对其进行引用。每个子查询根据不同的条件进行聚合计算,并返回结果中的 COMPANY_SEGMENT、one 和 two 列。
请注意,根据您的实际数据库结构和数据需求,您可能需要进行一些修改来适应您的环境。