回答編集履歴
2
構文
answer
CHANGED
|
@@ -4,6 +4,6 @@
|
|
|
4
4
|
|
|
5
5
|
を
|
|
6
6
|
id IN(SELECT id FROM login WHERE DATE(time)＝'2016-05-12')AND
|
|
7
|
-
id NOT IN (SELECT id FROM login WHERE DATE(time) ＝
|
|
7
|
+
id NOT IN (SELECT id FROM login WHERE DATE(time) ＝'2016-05-13')
|
|
8
8
|
|
|
9
9
|
と分けたら出ました。
|
1
構文
answer
CHANGED
|
@@ -3,7 +3,7 @@
|
|
|
3
3
|
id IN(SELECT id FROM login WHERE DATE(time) NOT IN ('2016-05-13')and DATE(time) IN('2016-05-12'))
|
|
4
4
|
|
|
5
5
|
を
|
|
6
|
-
id IN(SELECT id FROM login WHERE DATE(time)
|
|
6
|
+
id IN(SELECT id FROM login WHERE DATE(time)＝'2016-05-12')AND
|
|
7
|
-
id IN SELECT id FROM login WHERE DATE(time)
|
|
7
|
+
id NOT IN (SELECT id FROM login WHERE DATE(time) ＝ ('2016-05-13')
|
|
8
8
|
|
|
9
9
|
と分けたら出ました。
|