CREATE OR REPLACE VIEW FA_OBJECT_ASSETMX AS
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '163', G.currency_debet_amount) C,
decode(G.account, '163', G.currency_credit_amount) D,
decode(G.account, '165', G.currency_debet_amount) E,
decode(G.account, '165', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G 如上所述,我的account字段中的数据是161,162,163,164,165,我用上述语句查出的数据是161,163,165,但是我查处后,中间数据之间都有空行,我想应该是162,164的数据,应为不显示,所以出现空行想请教如何去掉空行,直接显示161,163,165
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '163', G.currency_debet_amount) C,
decode(G.account, '163', G.currency_credit_amount) D,
decode(G.account, '165', G.currency_debet_amount) E,
decode(G.account, '165', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G 如上所述,我的account字段中的数据是161,162,163,164,165,我用上述语句查出的数据是161,163,165,但是我查处后,中间数据之间都有空行,我想应该是162,164的数据,应为不显示,所以出现空行想请教如何去掉空行,直接显示161,163,165
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '163', G.currency_debet_amount) C,
decode(G.account, '163', G.currency_credit_amount) D,
decode(G.account, '165', G.currency_debet_amount) E,
decode(G.account, '165', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G
where G.account in ('161','163','165') --这样就去掉162,164的
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
max(decode(G.account, '161', G.currency_debet_amount)) A,
max(decode(G.account, '161', G.currency_credit_amount)) B,
max(decode(G.account, '163', G.currency_debet_amount)) C,
max(decode(G.account, '163', G.currency_credit_amount)) D,
max(decode(G.account, '165', G.currency_debet_amount)) E,
max(decode(G.account, '165', G.currency_credit_amount)) F
from VOUCHER_ROW_TAB G
group by G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount全加MAX试试看
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '163', G.currency_debet_amount) C,
decode(G.account, '163', G.currency_credit_amount) D,
decode(G.account, '165', G.currency_debet_amount) E,
decode(G.account, '165', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G
where g.account in ('161', '163', '165')
select G.account account,
G.currency_debet_amount currency_debet_amount,
G.currency_credit_amount currency_credit_amount,
decode(G.account, '161', G.currency_debet_amount) A,
decode(G.account, '161', G.currency_credit_amount) B,
decode(G.account, '163', G.currency_debet_amount) C,
decode(G.account, '163', G.currency_credit_amount) D,
decode(G.account, '165', G.currency_debet_amount) E,
decode(G.account, '165', G.currency_credit_amount) F
from VOUCHER_ROW_TAB G
where not (A is null and B is null and C is null and D is null and E is null and F is null)