朋友给了一道测试题:
用一条查询SQL统计某个字段各字符及出现的次数,并按出现次数倒序排列。
咋一看感觉很难,认真想想发现也并不是很难。以下是代码示例:
with t1 as
(
select 'hhjdbgydgdjd' str from dual
union all
select 'jdujgbhdg' str from dual
union all
select '514dgj1fgy' str from dual
) --构建临时表
select t1.str,/*t1.str,t2.lv,*/substr(t1.str,t2.lv,1) alp,count(substr(t1.str,