fork download
copy 
  1. create table ledger
  2.   (id integer, balance integer,
  3.     note text);
  4. insert into ledger values
  5.     (1, 100, 'ス2/21');
  6. insert into ledger values
  7.     (2, 200, 'ス11/21');
  8. insert into ledger values
  9.     (1, 110, '');
  10. insert into ledger values
  11.     (2, 220, '');
  12.  
  13. .headers on
  14. .mode csv
  15. select id, sum(balance) as sum from ledger
  16.     group by id;
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
Success #stdin #stdout 0s 4244KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
id,sum
1,210
2,420
https://ideone.com/ID6a1J
language:
SQLite (sqlite 3.27.2)
created:
3 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!