回答編集履歴

調整

2023/01/10 11:39

投稿

スコア114885

test CHANGED Viewed

@@ -16,5 +16,10 @@
 (3,100,'2023-01-01 03:00:00');
 select * from tbl as t1
+where not exists(
+  select 1 from tbl
-where not exists(select 1 from tbl where user_id=t1.user_id and created_at>t1.created_at);
+  where user_id=t1.user_id and created_at>t1.created_at
+  );
 ```