注册

求大佬指导指导

三金鑫 2022/03/28 856 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:7
【操作系统】:Windows
【CPU】:
【问题描述】*:SELECT
n.subject_label AS name,
x.topic AS topic,
x.num AS tabNum,
count( 1 ) AS fieldNum,
x.lvl AS type
FROM
( SELECT topic, count( 1 ) num, tab_id, lvl FROM pdi.pdi_meta_tab GROUP BY topic ORDER BY count( 1 ) DESC LIMIT 5 ) x
LEFT JOIN pdi.pdi_meta_tab_field f ON x.tab_id = f.tab_id
LEFT JOIN pdi.pdi_meta_subject n ON n.subject_name = x.topic

WHERE
(‘’ = ‘’ or x.lvl = ‘’ )

GROUP BY
f.tab_id

image.png
这个应该怎么改?

回答 0
暂无回答
扫一扫
联系客服