メモ:
メモ一覧
更新
-- 条件1:前日の値幅が5%以上 -- 条件2:前日の出来高100000以上 -- 条件3:100円以上、2000円以内 SELECT A.BRAND_CODE ,IFNULL(W.BRAND_NAME, 'NoName') AS BRAND_NAME ,A.END_AMT ,IFNULL(A.BEFORE_AMT,B.END_AMT) AS PRE_END_AMT ,B.START_AMT AS PRE_START_AMT ,B.HIGH_AMT AS PRE_HIGH_AMT ,B.VOLUME AS PRE_VOLUME FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = A.YMD) AND B.BRAND_CODE = A.BRAND_CODE LEFT JOIN BrandMaster W ON W.BRAND_CODE = A.BRAND_CODE WHERE A.YMD = (select MAX(Z.YMD) from EigyoCalendar Z) AND A.START_AMT > 1000 AND A.END_AMT > IFNULL(A.BEFORE_AMT,B.END_AMT) * 1.15 AND A.VOLUME > 100000000 / A.END_AMT ORDER BY A.YMD, A.VOLUME DESC