count where group by 查询问题求助

2015-05-04 09:53:51 226 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

android contentProvider group by查询数据比如要用实现这么一个sql语句： SELECT _id, number, date, duration, type, name, numbertype, numberlabel, COUNT(*) FROM calls GROUP BY number,type,date/8640000 ORDER BY date DESC 这个在一般的SQL编译工具里都能正常运行，在ContentRos 阅读详情

各位好，有个问题请教大家：



drop table ta;

drop table tb;



create table ta(

        id int(4) primary key not null auto_increment,

        user_id int (4),

        name varchar(10)

);



create table tb(

        id int(4) primary key not null auto_increment,

        fid int(4) comment 'ref ta.id',

        status int(1)

);



insert into ta(user_id,name) values(1,'lua');

insert into ta(user_id,name) values(1,'aix');

insert into ta(user_id,name) values(2,'java');

insert into ta(user_id,name) values(2,'cpp');

insert into ta(user_id,name) values(2,'csharp');

insert into ta(user_id,name) values(3,'linux');

insert into ta(user_id,name) values(9,'id');



insert into tb(fid,status) values(1,1);

insert into tb(fid,status) values(3,1);

insert into tb(fid,status) values(4,1);

insert into tb(fid,status) values(5,0);

insert into tb(fid,status) values(7,0);



select * from ta;

select * from tb;

select ta.id,ta.user_id,ta.name,tb.id as tbId,tb.fid,tb.status,count(tb.fid) countFid from ta left join tb on ta.id = tb.fid 

-- where tb.status = 1 

group by ta.id;