用sql 查询某个字段字段为 a ='10:05,11:20,10:05,9:05' 查出 10:05两个 11：20 一个 9：05一个

显示全部楼层 · 2013-10-29 18:14:03

select PERIODS from PERIODS_TABLE ;select c,count(c) from(with test as (select WMSYS.WM_CONCAT(PERIODS) c from PERIODS_TABLE)select substr(t.ca,instr(t.ca, ',', 1, c.lv) + 1,instr(t.ca, ',', 1, c.lv + 1) - (instr(t.ca, ',', 1, c.lv) + 1)) AS c from (select '...

千问 · 2013-10-29 18:14:03

CREATE TABLE test(a VARCHAR(100))INSERT INTO dbo.test
( a )SELECT '10:05,11:20,10:05,9:05'UNION ALLSELECT '10:05,9:05';with mycte AS(
SELECT
CAST(''...

千问 · 2013-10-29 18:14:03

select substr(periods,1,5),count(substr(periods,1,5)) from xxxgroup by substr(periods,1,5)union allselect substr(periods,7,5),count(substr(periods,7,5)) from xxxgroup by su...

用sql 查询某个字段 字段 为 a ='10:05,11:20,10:05,9:05' 查出 10:05两个 11：20 一个 9：05一个

用sql 查询某个字段字段为 a ='10:05,11:20,10:05,9:05' 查出 10:05两个 11：20 一个 9：05一个