表名:game_player
找出连续登录3天的用户,
大婶求教啊!
CREATE TABLE `game_player` (
`name` varchar(10) DEFAULT NULL,
`lastlogintime` datetime DEFAULT NULL,
`userid` varchar(10) DEFAULT NULL,
`lastlogouttime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
insert into game_player values ('a','20131001100000','20131001120000','1');
insert into game_player values ('a','20131002100000','20131002120000','1');
insert into game_player values ('a','20131003100000','20131003120000','1');
insert into game_player values ('a','20131004100000','20131004120000','1');
insert into game_player values ('b','20131001100000','20131001120000','2');
insert into game_player values ('b','20131002100000','20131002120000','2');
insert into game_player values ('c','20131003100000','20131003120000','3');
insert into game_player values ('d','20131001100000','20131001120000','4');
insert into game_player values ('d','20131002100000','20131002120000','4');
insert into game_player values ('d','20131004100000','20131004120000','4');
求大神帮助啊!!!