如何将两个不同的查询条件得到的结果存到一个数据集里？？

zosky 2003-02-08 10:43:02

查询一张表，最后得到像这样的结果
col1 col2
a d1
b d2
c d3 d4

col1和col2的查询条件不同，请问sql该怎么写？

...全文

32 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

chenchangfu 2003-02-15

打赏
举报

select BankCode , sum(TxnNum) from BasicDataPerDayOnBank_II
Where OBcbFlag='Rcv'
and OalId='A2'
and Rspcode='30'
and Datemsg like '200301%'
and InExCode='Intra'
and TxnCode in ('PCA','PPT','ACP','APT','ATZ','ATC')
and Left(BankCode,6) in ('080313','080402')
Group by BankCode ， Rspcode
order by BankCode，Rspcode

可以用
select BankCode , sum(TxnNum) from BasicDataPerDayOnBank_II
Where OBcbFlag='Rcv'
and OalId='A2'
and Rspcode='30'
and Datemsg like '200301%'
and InExCode='Intra'
and TxnCode in ('PCA','PPT','ACP','APT','ATZ','ATC')
and Left(BankCode,6) in ('080313','080402')
AND Rspcode in （12，14，30。。。）
Group by BankCode ， Rspcode
order by BankCode，Rspcode

zosky 2003-02-09

打赏
举报

好啊，实际就是统计各项数据，现在大概有四十多个吧，是分开的；
现在要弄到一个数据集里（四十多列），下面是现在用的的sql

select BankCode , sum(TxnNum) from BasicDataPerDayOnBank_II
Where OBcbFlag='Rcv'
and OalId='A2'
and Rspcode='12'
and Datemsg like '200301%'
and InExCode='Intra'
and TxnCode in ('PCA','PPT','ACP','APT','ATZ','ATC')
and Left(BankCode,6) in ('080313','080402')
Group by BankCode
order by BankCode

select BankCode , sum(TxnNum) from BasicDataPerDayOnBank_II
Where OBcbFlag='Rcv'
and OalId='A2'
and Rspcode='14'
and Datemsg like '200301%'
and InExCode='Intra'
and TxnCode in ('PCA','PPT','ACP','APT','ATZ','ATC')
and Left(BankCode,6) in ('080313','080402')
Group by BankCode
order by BankCode

select BankCode , sum(TxnNum) from BasicDataPerDayOnBank_II
Where OBcbFlag='Rcv'
and OalId='A2'
and Rspcode='30'
and Datemsg like '200301%'
and InExCode='Intra'
and TxnCode in ('PCA','PPT','ACP','APT','ATZ','ATC')
and Left(BankCode,6) in ('080313','080402')
Group by BankCode
order by BankCode

chenchangfu 2003-02-09