select name,sum(is_sucess) from ...
解决方案 »
- 有关rave打印问题
- 怎么让一个form在两分钟内没有鼠标和键盘点击就自动关闭,怎么做?
- 跪求高手解决方案,我所有程序的ado超作数据库都出错了:xx.exe raised excption class EOleExcepting with message,以前挺好!
- 怎么让我的程序支持utf-8编码??
- 这样的insert sql语句怎么写
- 各位大侠。。请帮个忙。。再线等待。。谢谢了!
- 谁精通或深入研究过DevExpress的控件?
- listview
- 用paradox能实现数据的缓冲吗?
- 如何用SQL语句选出两个表的不同记录!
- 怎样在调用API函数打开画图软件的同时将图片将某张图片加载到画图里直接编辑,而不用再次打开文件.
- 如何改变Button的颜色?
Select name,Count(is_success) from tablename
where is_success ='0'
Group by name1。成功
Select name,Count(is_success) from tablename
where is_success ='1'
Group by name
name | success | un_success
----------------|---------------|----------------
| |
select name,count(is_Success) as Success from table where is_Success=true and dodate>#2000-1-1# and dodate<#2000-12-31#
group by name
失败就为
select name,count(is_Success) as Success from table where is_Success=false and dodate>#2000-1-1# and dodate<#2000-12-31#
group by name
case is_success
when '1' count(is_success),
when '0', count(is_success),
group by name
用CASE好象可以 ,你先试一下
select name,
sum(case is_success when 'T' then 1 else 0) sucess,
sum(case is_success when 'F' then 1 else 0) fail
from table
group by name
sum(Decode(is_success,'T',1,0)) AS sucess,
sum(Decode(is_success,'F',1,0)) AS fail
from table
group by name