sqlite - 如何在 2 周内明智地编写记录查询？

Question

在查询之后，我已经为每周获取记录而写了。

Select a.VPA, STRFTIME('%W',b.ActualDateTime) as Week, sum(b.Amount) as Amount 
from STransDetails as b
Join SAccount as a On a.TransactionId = b.TransactionIdT 
WHERE a.VPA = 'vpa@HDL'
Group by Week

但我面临着 2 周明智的获取记录的写入查询的问题。请帮我！

标签： sqlite

Answer 1

您可以尝试将一周除以 2：-

Select a.VPA, STRFTIME('%W',b.ActualDateTime) / 2 as Week, sum(b.Amount) as Amount 
from STransDetails as b
Join SAccount as a On a.TransactionId = b.TransactionIdT 
WHERE a.VPA = 'vpa@HDL'
Group by Week