Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
select g.bankcode, a.type, a.currency, a.accountgroupid, sum(t.amount) as total_amount, 0 as sub_total_amount from alltransaction t inner join account a on a.id = t.accountid and a.currency = t.currency inner join accountgroup g on g.id = a.accountgroupid inner join currency c on c.currency = t.currency where a.id > 0 and a.id < 301 and t.currency = a.currency group by a.type, a.currency, a.accountgroupid, g.id, g.bankcode order by a.currency, g.id
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.