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));
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));
このブログ記事に対するトラックバックURL:
Comment feed