RT,闲话不说,看下sql 就明白我的意思了,根据file_name的后缀 分组 ,并且 计算出每组的数量。目前是自己写的
数量实现是小白 不会写了,望指点下。修改或重写整句sql都可以
SELECT DISTINCT (SUBSTR (files, INSTR (files, '.', -1, 1))) houzhui
FROM (WITH results AS
(SELECT *
FROM fw_file_version_info
WHERE branch = '2.2.7' AND UPPER (res) LIKE
'%TRA%')
SELECT DISTINCT (file_name) files
FROM results)
数量实现是小白 不会写了,望指点下。修改或重写整句sql都可以
SELECT DISTINCT (SUBSTR (files, INSTR (files, '.', -1, 1))) houzhui
FROM (WITH results AS
(SELECT *
FROM fw_file_version_info
WHERE branch = '2.2.7' AND UPPER (res) LIKE
'%TRA%')
SELECT DISTINCT (file_name) files
FROM results)
(SELECT *
FROM fw_file_version_info
WHERE branch = '2.2.7' AND UPPER (res) LIKE '%TRA%')SELECT (SUBSTR (files, INSTR (files, '.', -1, 1))) houzhui,--后缀
count(1)--数量
FROM (
SELECT DISTINCT (file_name) files FROM results)
GROUP BY SUBSTR (files, INSTR (files, '.', -1, 1)) --后缀分组
FROM fw_file_version_info t
WHERE branch = '2.2.7'
AND UPPER (res) LIKE '%TRA%'
GROUP BY SUBSTR(files, INSTR(files, '.', -1, 1));
from fw_file_version_info
where branch = '2.2.7' and upper (res) like '%TRA%'
group by substr(files, instr(files, '.', -1, 1));