id count1 count2
T0503001-1 9 0
T0503001-1 9 0
T0503001-1 9 4
C0804121 0 0
T0610003 0.016666 0
T0610003 0.016666 0
T0610003 0.016666 6
T0610003 0.016666 0
T0610003 0 0
T0610003 0.05 0
T0610003 0 0
select 出每个id的count1大于0的个数 和count2大于0的个数
解决方案 »
- TXT文件保存到sql数据库
- 我设计的表a(id,number) 其中id是主键,number是int型 我想当我输入的数据中,如果出现id相同的,用什么样的sql语言才能把number的数累加,而不用添加相同id的记录了。
- [MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER]用户'(null)'登陆失败。原因:未与信任SQL SERVER连接相关联
- SQL2008备份的数据库如何还原到SQL2005? 提示错误3241
- MS SQL SERVER 2008 Database Mail , sysmail_mailitmes 资料莫名消失.
- 关于远程备份
- 问一句 UPDATE 语句. [sql server]
- oracle初学者的问题,轻松拿到30分
- 请看一下一个查询的问题
- SQL 2008 R2建数据库镜像 1418 错误
- VB中如何实现这样的表格
- sql跨表查询
select * from 表 where count1 >0 and count1>0
where count1>0 group by id
union
select id ,count(count2)from Table
where count2>0 group by id
drop table wen5161
create table wen5161(id varchar(50), count1 float, count2 int)
insert into wen5161
select 'T0503001-1', 9 ,0 union all
select 'T0503001-1', 9 ,0 union all
select 'T0503001-1', 9, 4 union all
select 'C0804121' , 0 ,0 union all
select 'T0610003' ,0.016666 ,0 union all
select 'T0610003', 0.016666, 0 union all
select 'T0610003' ,0.016666, 6 union all
select 'T0610003', 0.016666 ,0 union all
select 'T0610003', 0 ,0 union all
select 'T0610003', 0.05, 0 union all
select 'T0610003', 0, 0 select distinct id , (select count(1) from wen5161 where count1> 0 and id = A.id),
(select count(1) from wen5161 where count2> 0 and id = A.id)
from wen5161 A
=======================C0804121 0 0
T0503001-1 3 1
T0610003 5 1
我要的是id对应的count1 和count2分别大于的次数 ,
得出格式如下 id count1 count2
T0610003 2 3请赐教!!