MYSQL查詢一周內(nèi)的數(shù)據(jù)(最近7天的)怎么寫？date(column_time)查詢一年：select * from table where DATE_SUB(CURDATE()， INTERVA

MYSQL查詢一周內(nèi)的數(shù)據(jù)(最近7天的)怎么寫？

date(column_time)查詢一年：select * from table where DATE_SUB(CURDATE()， INTERVAL 1 YEAR) DATE_ADD((select createdate from tb_equity ORDER BY createdate DESC limit 1) ，INTERVAL -7 day)and (select createdate from tb_equity ORDER BY createdate DESC limit 1) >= createdate3，sql查詢表中的重復(fù)數(shù)據(jù)select * from 表名 where 字段名 in (select 字段名 from 表名 group by 字段名 HAVING COUNT(*) > 1) order by 表名

mysql查詢一周內(nèi)每天的記錄數(shù)？

$re = mysql_query("SELECT count(*) as n， (TO_DAYS( NOW( ) ) - TO_DAYS( regtime)) as `d` FROM members group by TO_DAYS( regtime) having d " echo $rc["n"] //這個是數(shù)量}