» 2013 » January » 07 の記事

~ Mysql 取出任意3天的record ~

connie 2013.01.07 | mysql | | No Comments
SELECT `accountname` FROM `tablename` 
where `log_date`>'2012-12-30 00:00:00' 
and `log_date`<'2013-01-03 23:59:59' 
group by `log_date`,`accountname` 
having COUNT(DISTINCT date(log_date));

 

| HOME |

Smiley face

January 2013
S M T W T F S
 12345
6789101112
13141516171819
20212223242526
2728293031