Home > database >  Trouble ask next, how to write the SQL
Trouble ask next, how to write the SQL

Time:05-20

Monthly unit bank amount
12 A bank of China, 12
12 A construction bank 11
12 A minsheng 11
Bank of China, 11 12 B
Construction bank 11 12 B
11 A construction bank 11

Presenting the
Monthly unit of bank of China construction bank other
12 A, 12 November 11
12 B 11 11 0
11 A 11 0 0
Note: as long as it doesn't belong to the bank of China with minsheng bank is added to the other
  • Related