CREATE TABLE 'test'('mac' varchar(20) not null,'dateString' varchar(20) not null,'stepnum' integer,'activitytime' integer default(0),primary key ('mac' , 'dateString'));
select * from dbstepct where step != 0;
select sum(step) from dbstepct group by dateString;
select sum(step) as stepnum, mac, dateString from dbstepct order by datetime(dateString) asc;
select sum(step) as stepnum,dateString from dbstepct ;
select SUBSTR(dateString,1,10) as a from dbstepct;
select sum(step) as stepnum, SUBSTR(dateString,1,10) as dateString, mac from dbstepct group by SUBSTR(dateString,1,10)
select * from test
select * from dbstepct where step != 0;
select sum(step) from dbstepct group by dateString;
select sum(step) as stepnum, mac, dateString from dbstepct order by datetime(dateString) asc;
select sum(step) as stepnum,dateString from dbstepct ;
select SUBSTR(dateString,1,10) as a from dbstepct;
select sum(step) as stepnum, SUBSTR(dateString,1,10) as dateString, mac from dbstepct group by SUBSTR(dateString,1,10)
select * from test
insert into dbcurrentsportct(stepnum, dateString, mac) select sum(step) as stepnum, SUBSTR(dateString,1,10) as dateString, mac from dbstepct group by SUBSTR(dateString,1,10)
分组查询并去重
insert into dbcurrentsportct(stepnum, dateString, mac) select sum(step) as stepnum, SUBSTR(dateString,1,10) as dateString, mac from dbstepct as tb where tb.dateString in (select dbcurrentsportct.[dateString] from dbcurrentsportct)
group by SUBSTR(dateString,1,10)