select * from tb_login t where logindate >= curdate() and not exists (select 1 from tb_login where name=t.name and logindate>= curdate() and logindate<t.logindate)
如果就name和logindate两个字段的话 可以 select name,min(logindate) from tb where logindate >= curdate() group by name
我怎么感觉都不太对啊 select name,min(logindate) from tb_login where logindate=currendate() group by name; select currendate(); 2013-07-16 我怎么感觉都不太对啊 select name,min(logindate) from tb_login where logindate=currendate() group by name; select currendate(); 2013-07-16
select * from tb_login where logindate in( select min(logindate) from tb_login group by name,logindate ); 这是查询每个人每天的初次登陆
只是 一张表,这种取 分组取最大最小,用 max 和 min 函数还是比较好的 select curdate()是取当前日期。结果如:2013-07-26 select now()是取现在具体时间。结果如:2013-07-26 11:11:27 select name,min(logindate) from tb_login where logindate >= curdate() group by name order by logindate。
SELECT count(*) AS count, name, unix_timestamp(logindate) FROM login GROUP BY name HAVING min(unix_timestamp(logindate)) > unix_timestamp(CURdate());
from tb_login t
where logindate >= curdate()
and not exists (select 1 from tb_login where name=t.name and logindate>= curdate() and logindate<t.logindate)
select name,min(logindate)
from tb
where logindate >= curdate()
group by name
select name,min(logindate)
from tb_login
where logindate=currendate()
group by name;
select currendate();
2013-07-16
我怎么感觉都不太对啊
select name,min(logindate)
from tb_login
where logindate=currendate()
group by name;
select currendate();
2013-07-16
select min(logindate) from tb_login group by name,logindate );
这是查询每个人每天的初次登陆
select now()是取现在具体时间。结果如:2013-07-26 11:11:27
select name,min(logindate) from tb_login where logindate >= curdate() group by name
order by logindate。
name,
unix_timestamp(logindate)
FROM login
GROUP BY name
HAVING
min(unix_timestamp(logindate)) > unix_timestamp(CURdate());