select sum(case type when 'y' then 1 else 0 end) [Y Total], sum(case type when 'n' then 1 else 0 end) [N Total] from tb
如果是想统计这两种记录的各自数量 select [type],count(1) [count] from 表 group by [type] --------- type count y ? n ?
--try select sum(case when type='y' then 1 else 0 end), sum(case when type='n' then 1 else 0 end) from tbName
create table T(type char(1)) insert T select 'y' insert T select 'y' insert T select 'y' insert T select 'n'select y_count=sum(case when type='y' then 1 else 0 end), n_count=sum(case when type='n' then 1 else 0 end) from T--result y_count n_count ----------- ----------- 3 1(1 row(s) affected)
create table T(type char(1)) insert T select 'y' insert T select 'y' insert T select 'y' insert T select 'n'select type, 數量=count(*) from T group by type order by 2 desc--result type 數量 ---- ----------- y 3 n 1(2 row(s) affected)
create table T(type char(1)) insert T select 'y' insert T select 'y' insert T select 'y' insert T select 'n'select type, 數量=count(*) from T group by type order by 2 desc--result type 數量 ---- ----------- y 3 n 1(2 row(s) affected)
select count(*) from table group by type 你标题起的和这题的难度完全反比额
sum(case type when 'n' then 1 else 0 end) [N Total] from tb
select [type],count(1) [count] from 表 group by [type]
---------
type count
y ?
n ?
select
sum(case when type='y' then 1 else 0 end),
sum(case when type='n' then 1 else 0 end)
from tbName
insert T select 'y'
insert T select 'y'
insert T select 'y'
insert T select 'n'select
y_count=sum(case when type='y' then 1 else 0 end),
n_count=sum(case when type='n' then 1 else 0 end)
from T--result
y_count n_count
----------- -----------
3 1(1 row(s) affected)
insert T select 'y'
insert T select 'y'
insert T select 'y'
insert T select 'n'select
type,
數量=count(*)
from T
group by type
order by 2 desc--result
type 數量
---- -----------
y 3
n 1(2 row(s) affected)
insert T select 'y'
insert T select 'y'
insert T select 'y'
insert T select 'n'select
type,
數量=count(*)
from T
group by type
order by 2 desc--result
type 數量
---- -----------
y 3
n 1(2 row(s) affected)
你标题起的和这题的难度完全反比额