回答編集履歴

推敲

2019/04/12 10:56

投稿

スコア25184

test CHANGED Viewed

@@ -4,13 +4,13 @@
 SELECT SEIHIN, SAGYODATE, SEQ, NAIYO
-		 , lag(SAGYODATE) over(partition by seihin order by SAGYODATE, SEQ) AS SAGYODATE2
+     , lag(SAGYODATE) over(partition by seihin order by SAGYODATE, SEQ) AS SAGYODATE2
-		 , lag(SEQ) over(partition by seihin order by SAGYODATE, SEQ) AS SEQ2
+     , lag(SEQ) over(partition by seihin order by SAGYODATE, SEQ) AS SEQ2
-FROM 	SAGYORIREKI
+FROM   SAGYORIREKI
-WHERE   SAGYODATE BETWEEN TO_DATE('2017/06/01','YYYY/MM/DD')
+WHERE  SAGYODATE BETWEEN TO_DATE('2017/06/01','YYYY/MM/DD')
                       AND TO_DATE('2018/11/30','YYYY/MM/DD')