回答編集履歴

1

全員分

2019/03/12 11:34

投稿

yambejp
yambejp

スコア114572

test CHANGED
@@ -29,3 +29,35 @@
29
29
 
30
30
 
31
31
  ```
32
+
33
+
34
+
35
+ # 追記
36
+
37
+
38
+
39
+ 全員分
40
+
41
+ ```SQL
42
+
43
+
44
+
45
+ SELECT employee_id,t1.div_id FROM `m_test_div_master` as t1
46
+
47
+ inner join m_test_employee_divs as t2
48
+
49
+ on t1.div_id=t2.div_id
50
+
51
+ where not exists(
52
+
53
+ SELECT 1 FROM `m_test_div_master` as t3
54
+
55
+ inner join m_test_employee_divs as t4
56
+
57
+ on t3.div_id=t4.div_id
58
+
59
+ where t4.employee_id=t2.employee_id and t1.order > t3.order)
60
+
61
+
62
+
63
+ ```