--投稿数(不包括暂不处理的),采稿数,
select t1.personid,t2.投稿数,t3.采稿数
from info t1 left join
(select personid,count(1) as 投稿数 from info where status <> 'w') t2 on t1.personid = t2.personid left join
(select personid,count(1) as 采稿数 from info where status = 'y') t3 on t1.personid = t3.personid
你所说的:积分,采稿率的整体信息,这些描述不清楚,无从考证
select t1.personid,t2.投稿数,t3.采稿数
from info t1 left join
(select personid,count(1) as 投稿数 from info where status <> 'w') t2 on t1.personid = t2.personid left join
(select personid,count(1) as 采稿数 from info where status = 'y') t3 on t1.personid = t3.personid
你所说的:积分,采稿率的整体信息,这些描述不清楚,无从考证
解决方案 »
- 如何在存储过程中使一个表中的列值等于另外两列的算术表达式的值?
- sql2000 存图片问题
- 有个ID字段里面有值:100 101 103 105 106 108....
- 求一查询sql语句
- SQL更新问题现有A表(InvID,Qty1,Qty2),B表(InvID,Qty),现在要更新表A.Qty2=A.Qty2+B.qty where A.Inv
- 求一个sql写法
- 看了很多sql 导入access表的命令,但是都不行,麻烦看看
- 菜鸟问题!关于修改表字段的默认值!
- 送分罗!!!!!!!!连接多,会影响系统性能吗,进来拿分吧!
- 关于时间函数问题
- 求:一个循环找出所有上级的SQL语句
- ADOQuery 的问题,查询带参数的SQL语句不成功
from info t1 left join
(select personid,count(1) as 投稿数 from info where status <> 'w' group by personid) t2 on t1.personid = t2.personid left join
(select personid,count(1) as 采稿数 from info where status = 'y' group by personid) t3 on t1.personid = t3.personid