iOS SQL查询
2023-02-21 本文已影响0人
不要虚度美好的时光
1. 按组查询
SELECT strftime('%Y-%m-%d', datetime(spendOrIncomeDate, 'unixepoch')) AS day, *
FROM RevenueAndExpenditureRecordsTB
GROUP BY day;
image.png
image.png
image.png
SELECT strftime('%Y-%m-%d', datetime(spendOrIncomeDate, 'unixepoch')) AS day, *
FROM RevenueAndExpenditureRecordsTB
GROUP BY day;
