db2物化路径模型查询

--物化路径模型 --自顶到底的查询 SELECTa.materialized_path,a.commander,a.description FROMt_materialized_modelASa,t_materialized_modelASb WHEREa.materialized_pathLIKECONCAT(b.materialized_path,'%')ANDb.description='雨恬'orderbymaterialized_path --自底到顶的查询 SELECTa.materialized_path,a.comma