求大神看下，這段查詢為什么不處結果，一直在查詢中
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
Indices.databaseName = temp_table.databaseName and
Indices.tableName = temp_table.tableName
)sel * from temp_table
QUALIFY ROW_NUMBER()OVER(PARTITION BY databasename,tableName ORDER BY num desc)=1;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/89175.html
標籤：開發