• 
  uuid不能生成一列，目前表里ID没有数据，填报时只有一个，不能向下扩展

  283个浏览 2个回答 2022年09月02日发布
• 
  查询是要列出当前选择年份及当前年份前四年的数据

  320个浏览 4个回答 2022年08月30日发布
• 
  这个数据集应该怎样写？报错TMMP

  WITH INFO AS (SELECT${if(WEEK="月","MT.FMONTH AS TMP, ","MT.FWEEK AS TMP, ")} ${if(WEIDU="按班组","WEH.SHIFT AS TMMP, ",IF(WEIDU="按员工","WEH.JOCKEY AS TMMP, ",IF(WEIDU="按产品contype","WEH.PRODUCT_TYPE AS TMMP, ",IF(WEIDU="按检验阶段","WEH.INSPECTION_STAGE AS TMMP, ",IF(WEIDU="按浸渍线","WEH.IMPREGNATION_LINE AS TMMP, ","")))))} WEH.HOLE_QUANTITY AS NUM,WEH.MACHINE,WEH.HOLE_AREAFROM MDM_TIME MTLEFT JOIN WR_ET_QUALITY_HOLE WEH ON MT.FYMDAY =  WEH.INVESTIGATION_DATE  WHERE MT.FYEAR = '${NIAN}' )SELECTTMP,TMMP,SUM(NUM) AS 数量,MACHINEFROM INFOWHERE 1=1${IF(LEN(MUN)=0,"","AND TMP= '"+MUN+"' ")}${IF(LEN(QUYU)=0,"","AND HOLE_AREA = '"+QUYU+"'")}GROUP BY TMP,TMMP,MACHINEORDER BY TMP+0

  244个浏览 1个回答 2022年08月19日发布
• 
  这个数据集应该怎样定义？？选择周月和不同的维度，过滤出不同的数据

  WITH WER AS (SELECTINVESTIGATION_DATE AS 调查时间,JOCKEY AS 操作工,SHIFT AS 班次, PRODUCT_TYPE AS 产品类型,INSPECTION_STAGE AS 检验阶段,HOLE_AREA AS 孔洞区域,HOLE_QUANTITY AS 孔洞数量FROM WR_ET_QUALITY_HOLE),QWR AS( SELECT  DISTINCT  MDM_TIME.FWEEK AS 周,MDM_TIME.FMONTH AS 月,WR_ET_QUALITY_HOLE.INVESTIGATION_DATE 日期FROM WR_ET_QUALITY_HOLELEFT JOIN MDM_TIME ON WR_ET_QUALITY_HOLE.INVESTIGATION_DATE = MDM_TIME.FYMDAY)SELECT WER.操作工,WER.检验阶段,WER.孔洞区域,WER.孔洞数量,WER.班次,WER.产品类型,QWR.周,QWR.月FROM WER LEFT JOIN QWR ON WER.调查时间= QWR.日期

  305个浏览 1个回答 2022年08月15日发布
• 
  怎样在选择不同的参数下扩展不一样的内容被

  222个浏览 1个回答 2022年08月15日发布
• 
  横向扩展怎样设置父子格，

  291个浏览 1个回答 2022年08月12日发布

26

4

26

10