回答編集履歴

1

回答修正

2020/02/10 08:52

投稿

Y.H.
Y.H.

スコア7918

test CHANGED
@@ -6,10 +6,10 @@
6
6
 
7
7
  from
8
8
 
9
- (select ID, max(FLG) as flg from tableA group by ID)
9
+ (select ID, max(FLG) as maxflg from tableA group by ID)
10
10
 
11
11
  where
12
12
 
13
- flg = 0;
13
+ maxflg = 0;
14
14
 
15
15
  ```