請大神看下這段查詢為什么不處結果，一直在查
with recursive temp_table (databasename,tableName,ColumnName,num) as
(
select
DatabaseName,
tablename,
ColumnName,
1
from Indices
union all
select
temp_table.databasename,
temp_table.tableName ,
Indices.ColumnName||','|| temp_table.ColumnName,
temp_table.num+1
from
temp_table ,
Indices
where
temp_table.databaseName=Indices.databaseName
and temp_table.tableName=Indices.tableName
)sel * from temp_table
QUALIFY ROW_NUMBER()OVER(PARTITION BY databasename,tableName ORDER BY num desc)=1;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/89174.html
標籤：開發
上一篇：在安裝10G時出錯