永洪社区

标题: 数据集用参数 [打印本页]

作者: yhdata_lcIvgQYx 时间: 2023-4-11 15:43
标题: 数据集用参数
数据集用了参数为什么参数传进去的数值都是

SELECT a.ghrc, b.flmc, b.ksmc, a.ghrq FROM (SELECT ghrc, ksbzdm, ghrq FROM tmsghmxft WHERE 1 = 1 AND ghrq >= 'replaced_placeholder' AND ghrq < 'replaced_placeholder') AS a LEFT JOIN (SELECT bzdm, flmc, ksmc FROM TKSDMDM) AS b ON a.ksbzdm = b.bzdm WHERE 1 = 1 AND c.ksmc IN ('replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder', 'replaced_placeholder') AND c.flmc IN ('replaced_placeholder')”

作者: yhdata_ruby 时间: 2023-4-11 15:47
怎么写的sql呀，是做了什么操作，现在的数据是什么样的

欢迎光临永洪社区 (https://club.yonghongtech.com/)