Created
June 4, 2025 14:04
-
-
Save v5tech/c9b292b3de332bc93ae11c6fa31f56f5 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE TABLE trains AS | |
FROM "http://blobs.duckdb.org/train_services.parquet"; | |
FROM trains; | |
COPY (FROM trains) TO "./trains.csv"; | |
FROM "./trains.csv"; | |
SELECT * FROM read_csv_auto('user.csv', header=true); | |
CREATE TABLE tcs_bill_summary AS | |
SELECT * FROM read_csv_auto('/Users/fengj/Downloads/L3-明细账单/*.csv', | |
header=true, | |
encoding='UTF-8', | |
nullstr='-' | |
); | |
select count(*) from tcs_bill_summary; | |
select REPLACE("账单月", CHR(9), '') as "账单月","产品名称",sum("现金支付(元)") as "现金支付" from tcs_bill_summary group by "账单月","产品名称" order by "账单月"; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment