12 lines
249 B
SQL
12 lines
249 B
SQL
/*.open energiemon.db*/
|
|
.mode csv
|
|
.separator ';'
|
|
.header on
|
|
|
|
select mon
|
|
, replace (gasKWhSum,'.',',') as gasKWhSum
|
|
, replace (stromKWhSum,'.',',') as stromKWhSum
|
|
, replace (wasserQmSum,'.',',') as wasserQmSum
|
|
from vmonatssummen ;
|
|
|