请sqlserver 高手 解决

Question

     表名db_test      id    value
      1       a
      2       a
      3       b
      4       b
      .       c      
         请用sql 语句查询出 字母在该表中出现的次数
 

Answer 1

select [value], count([value]) as '次数' from  db_test  group by [value]

Answer 2

SELECT * FROM TC
/*
ID          col                                                num         
----------- -------------------------------------------------- ----------- 
1           aa,bb,cc                                           10
2           aa,aa,bb                                           20
3           aa,aa,bb                                           30
5           ddaa,ccc                                           40
6           eee,ee,c                                           50
4           dd,ccc,c                                           60
7           aa,bb,cc                                           80
*/SELECT SUM(LEN(REPLACE(COL,'a','ao'))-LEN(COL)) FROM TC
/*
----------- 
14
*/

Answer 3

--创建测试表
create table db_test(pid int,pvalue char(1))--插入数据
insert into db_test
select 1,'a' union all
select 2,'a' union all
select 3,'b' union all
select 4,'b' union all
select 5,'c' union all
select 6,'c' union all
select 7,'c'--用3楼
select pvalue, count(pvalue) as times from db_test
group by pvalue--用3楼结果
pvalue times
a 2
b 2
c 3
--用5楼,查询 字母a出现次数
SELECT SUM(LEN(REPLACE(pvalue,'a','ao'))-LEN(pvalue)) as times FROM db_test--用5楼结果
times
2--删除测试数据
drop table db_test