情景:某一字段有子父级关系,找出此记录属于第几级,同时找出是否是最末级
sql语句
WITHtradertype(tradetypeid,code,lcode,name,parentid,class_level)
AS (SELECT
a.tradetypeid
,a.code
,a.lcode
, a.name
,a.parentid,
1 AS class_level
FROMl_tradertype a where parentid IS NULL
UNION ALL
SELECT
l.tradetypeid
,l.