メモ：メモ一覧
更新

-- 月足下値ラインに接触 SELECT (((A.LOW_AMT - B.LOW_AMT) / (AA.TIME_NUM - BB.TIME_NUM)) * (159 - AA.TIME_NUM) + A.LOW_AMT) AS AA ,S.* FROM EveryDay4Data S INNER JOIN EveryMonth4LowData A ON A.BRAND_CODE = S.BRAND_CODE AND A.YM = (select MAX(Z.YM) FROM EveryMonth4LowData Z WHERE Z.BRAND_CODE = A.BRAND_CODE) INNER JOIN EveryMonth4LowData B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM = A.TIME_NUM - 1 INNER JOIN EveryMonth4Data AA ON AA.BRAND_CODE = A.BRAND_CODE AND AA.YM = A.YM INNER JOIN EveryMonth4Data BB ON BB.BRAND_CODE = B.BRAND_CODE AND BB.YM = B.YM INNER JOIN EveryDay4Data W ON W.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = S.YMD) AND W.BRAND_CODE = S.BRAND_CODE WHERE S.YMD = '20191202' AND S.LOW_AMT <= (((A.LOW_AMT - B.LOW_AMT) / (AA.TIME_NUM - BB.TIME_NUM)) * (159 - AA.TIME_NUM) + A.LOW_AMT) AND W.LOW_AMT > (((A.LOW_AMT - B.LOW_AMT) / (AA.TIME_NUM - BB.TIME_NUM)) * (159 - AA.TIME_NUM) + A.LOW_AMT) AND A.LOW_AMT > B.LOW_AMT AND S.VOLUME > 10000000 /S.END_AMT