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

回答編集履歴

2

構文

2016/05/17 03:04

投稿

sato_day
sato_day

スコア20

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) = ('2016-05-13')
7
+ id NOT IN (SELECT id FROM login WHERE DATE(time) ='2016-05-13')
8
8
 
9
9
  と分けたら出ました。

1

構文

2016/05/17 03:04

投稿

sato_day
sato_day

スコア20

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) NOT IN ('2016-05-13')AND
6
+ id IN(SELECT id FROM login WHERE DATE(time)'2016-05-12')AND
7
- id IN SELECT id FROM login WHERE DATE(time) IN ('2016-05-12')
7
+ id NOT IN (SELECT id FROM login WHERE DATE(time) ('2016-05-13')
8
8
 
9
9
  と分けたら出ました。