coco2d_x2014
甄齐才
2019-01-02 21:08

SqlServer With tableName as怎么转成Oracle sql语句?

  • oracle
  • sql

WITH cte
AS ( SELECT id ,
key
FROM result
WHERE label = '姜山'
AND type = 'ROUTE'
UNION ALL
SELECT g.id ,
cte.key
FROM result g
INNER JOIN cte ON g.parentid = cte.id
)
SELECT ccc.result_CODE ,
ccc.result_NAME ,
aaa.*
INTO #temp4
FROM result aaa
INNER JOIN cte bbb ON bbb.id = aaa.id
INNER JOIN main ccc ON aaa.key = ccc.id
WHERE aaa.label LIKE '%资料%';

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答