回答編集履歴
2
桁を揃えた
answer
CHANGED
|
@@ -15,8 +15,9 @@
|
|
|
15
15
|
, LAG(error_code) OVER(ORDER BY error_date) AS LAG_error_code
|
|
16
16
|
FROM tr_machine_error
|
|
17
17
|
), SUB2 AS (
|
|
18
|
-
SELECT *
|
|
18
|
+
SELECT *
|
|
19
|
-
, CASE WHEN (machine, error_code) <> (LAG_machine, LAG_error_code)
|
|
19
|
+
, CASE WHEN (machine, error_code) <> (LAG_machine, LAG_error_code)
|
|
20
|
+
THEN 1 ELSE 0 END AS FLG
|
|
20
21
|
, SUM(CASE WHEN (machine, error_code) <> (LAG_machine, LAG_error_code)
|
|
21
22
|
THEN 1 ELSE 0 END) OVER(ORDER BY error_date) AS グループ番号
|
|
22
23
|
FROM SUB
|
1
リンクを作成
answer
CHANGED
|
@@ -5,7 +5,7 @@
|
|
|
5
5
|
せっかくですのでコメントしました。
|
|
6
6
|
返信は不要です。
|
|
7
7
|
|
|
8
|
-
https://www.db-fiddle.com/f/oPHaxqhi65azrJAUzetRGT/0
|
|
8
|
+
[https://www.db-fiddle.com/f/oPHaxqhi65azrJAUzetRGT/0](https://www.db-fiddle.com/f/oPHaxqhi65azrJAUzetRGT/0)
|
|
9
9
|
|
|
10
10
|
|
|
11
11
|
```SQL
|