• 
  请问mysql怎么筛选二个字段需要is_type=1的数据和type=2的数据

  448个浏览 4个回答 2022年12月14日发布
• 
  这样写有问题吗

  SQL("PM4", "select sum(TOTAL) from BMS_SA_DTLQRY_V where to_char(CREDATE,'yyyy-mm')= '" +M2+ "' AND PRODAREA = '"+D2+ "' AND PROVINCENAME='"+E2+"' AND CITYNAME='"+F2+"'" , 1, 1)

  339个浏览 3个回答 FineReport 2021年05月31日发布
• 
  请问怎么运算范围sql

  比如 SAFETYSTOCK*0.9<QTY<SAFETYSTOCK*1.1  在QTY这个值范围之内 为 1 如果大于2 小于 3SELECT s.FNUMBER,s.SAFETYSTOCK,y.QTYFROM MC_INVENTORY_SECURITY s left join MC_INVENTORY_QTY y on y.ITEMCODE=s.FNUMBER

  542个浏览 4个回答 SQL 2021年07月26日发布
• 
  js点击按钮怎么获取输入框的值

  437个浏览 2个回答 FineReport 2021年07月23日发布
• 
  分组请问怎么相加

  SELECT nvl(sum(t.QUANTITY),0) as QUANTITY,t.INSPSTATUSNAME,nvl(t1.QUANTITYt,0),t.INSPSTATUS,TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy-mm') as tdata, case t.INSPSTATUS when 'Unqualified' then '2'                   when 'Qualified' then '1' when 'Waiting' then '3'                            else '4'          end as status,TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'mm') as month,TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy') as year,SYSDATE,nvl(t2.folt,0) as folt,nvl(t3.countfolt,0) as countfoltFROM WMS_STORAGELIST t LEFT JOIN (select    TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm') as year_mon,   sum(QUANTITY) as QUANTITYt,INSPSTATUSNAME  FROM WMS_STORAGELIST  GROUP BY  TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm'),INSPSTATUSNAME   )t1 on t1.INSPSTATUSNAME=t.INSPSTATUSNAME and to_char(add_months(to_date(t.FDATE,'yyyy-mm-dd'),-12),'yyyy-mm')=t1.year_mon LEFT JOIN ( select COUNT(DISTINCT FACTORYLOTNO || WORKLOTNO) as folt,INSPSTATUSNAME,TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm') as year_mon2 from WMS_STORAGELIST GROUP BY INSPSTATUSNAME,TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm') ) t2 on t2.INSPSTATUSNAME=t.INSPSTATUSNAME and TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy-mm')=t2.year_mon2 LEFT JOIN ( select COUNT(DISTINCT FACTORYLOTNO || WORKLOTNO) as countfolt,INSPSTATUSNAME,TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm') as year_mon2 from WMS_STORAGELIST GROUP BY INSPSTATUSNAME,TO_CHAR(to_date(FDATE,'yyyy-mm-dd'),'yyyy-mm') ) t3 on t3.INSPSTATUSNAME=t.INSPSTATUSNAME and to_char(add_months(to_date(t.FDATE,'yyyy-mm-dd'),-12),'yyyy-mm')=t3.year_mon2where t.FDATE>='2021'GROUP BY t.INSPSTATUSNAME,TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy-mm'),TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'mm'),TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy') ,t1.QUANTITYt,t.INSPSTATUS,t2.folt,t3.countfoltORDER BY TO_CHAR(to_date(t.FDATE,'yyyy-mm-dd'),'yyyy-mm')

  556个浏览 3个回答 SQL 2021年07月22日发布
• 
  请问求昨日环比

  select sum(v.OUTQTY),to_char(v.CREDATE,'yyyy-mm-dd'),to_char(v.CREDATE,'mm'),to_char(v.CREDATE,'yyyy'),v.ENTRYID from bms_st_io_dtl_unit_qry_v vwhere v.inoutflag='0' GROUP BY to_char(v.CREDATE,'yyyy-mm-dd'),to_char(v.CREDATE,'mm'),to_char(v.CREDATE,'yyyy'),v.ENTRYID

  350个浏览 2个回答 SQL 2021年07月14日发布
• 
  怎么查询传入参数减一年

  269个浏览 3个回答 FineReport 2021年07月13日发布
• 
  请问减一年查询

  select * from(select to_number(to_CHAR(FBIZDATE,'yyyy')),FLOATT,FBIZDATE,FMATERIALID,CFTESTNUMBER,FCOSTCENTERORGUNITID,FCUSTOMERID,FDESCRIPTION,FQTY,FINQTY,FQTYBALANCE,REMARKS,FNUMBER FROM T_IM_BALANCE_QTY  where to_number(to_CHAR(FBIZDATE,'yyyy')-1)='2021' and FMATERIALID='010104001802'UNION allselect to_number(to_CHAR(FBIZDATE,'yyyy')),FLOATT,FBIZDATE,FMATERIALID,CFTESTNUMBER,FCOSTCENTERORGUNITID,FCUSTOMERID,FDESCRIPTION,FQTY,FINQTY,FQTYBALANCE,REMARKS,FNUMBER FROM T_IM_BALANCE_QTY  where to_number(to_CHAR(FBIZDATE,'yyyy'))='2021' and FMATERIALID='010104001802') a ORDER BY FBIZDATE

  391个浏览 4个回答 SQL 2021年07月13日发布
• 
  请问单元格怎么累计计算

  377个浏览 1个回答 FineReport 2021年07月05日发布
• 
  单元格怎么过滤判断显示问题

  261个浏览 1个回答 FineReport 2021年07月02日发布

45

26

45

10