select rank() over(order by t.treecode) rowno
,decode (rank() over(order by t.treecode) rowno,
1,'一',
2,'二',
3,'三',
4,'四',
5,'五',
6,'六',
7,'七',
8,'八',
'九') as asdf
, t.code
, t.name as name1
from ip_ct_goodJob_assessType t order by t.treecode
我不用decode判断输出数字 用哪个分析函数就没错。。怎么我放到decode判断函数里 在用个分析函数他就会给我报错
求帮助。。。。。 Oracle select SQL
------解决方案--------------------
select rank() over(order by t.treecode) rowno
,decode (rank() over(order by t.treecode),--去掉里面的rowno
1,'一',
2,'二',
3,'三',
4,'四',
5,'五',
6,'六',
7,'七',
8,'八',
'九') as asdf
, t.code
, t.name as name1
from ip_ct_goodJob_assessType t order by t.treecode