回答率: 85.48%

質問するログイン新規登録

トップ MySQLに関する質問 case文とwhere文の併用

編集履歴

回答編集履歴

3

修正

2018/05/10 02:06

投稿

スコア25173

test CHANGED Viewed

@@ -22,7 +22,7 @@
           not exists(select 1 from cp_plan where id = 176)
-      and id in (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
+      and id = (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )

2

修正

2018/05/10 02:06

投稿

スコア25173

test CHANGED Viewed

@@ -22,7 +22,7 @@
           not exists(select 1 from cp_plan where id = 176)
-      and id=(select mid from (SELECT max(id) as mid from cp_plan) as tmp)
+      and id in (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )

1

修正

2018/05/10 01:58

投稿

スコア25173

test CHANGED Viewed

@@ -22,7 +22,7 @@
           not exists(select 1 from cp_plan where id = 176)
-      and id=(SELECT max(id) from cp_plan)
+      and id=(select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )