SQLite Qurey获取每周数据 [英] SQLite Qurey to get weekly data's

问题描述

嗨
如何使用sqlite查询获取每周数据.

如果从该日期中选择一个日期，则需要每周一次获取数据.

问候，
karthick

Hi
How to get weekly data using sqlite query .

if select one date from that date i need to get data accordly weekly .

Regards,
karthick

推荐答案

您提供的信息不多，下面是一个示例查询:

You haven''t supplied much to go on, but here''s an example query:

SELECT COUNT(*),STRFTIME('%Y-%W',created,'unixepoch') AS creat 
FROM Files GROUP BY creat

该查询计算文件"表中的条目数，按周分组.

SQLite日期函数: http://www.sqlite.org/lang_datefunc.html [

This query counts the number of entries in the Files table, grouped by week.

SQLite date functions: http://www.sqlite.org/lang_datefunc.html[^]

这篇关于SQLite Qurey获取每周数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！