向高手们请教一个SQL语句!

Question

select * from yourtable where yourDATETIME between 
DATE_SUB(CURRENT_DATE,INTERVAL 10 DAY) and DATE_SUB(CURRENT_DATE,INTERVAL 1 DAY);

Answer 1

SELECT .. FROM ... 
  GROUP BY  FLOOR((TO_DAYS(NOW()) - TO_DAYS(`RegisterTime`)) / 10)

Answer 2

也可这样用，虽然长点，但速度会快点
select 
sum(yourDATETIME between 
DATE_SUB(CURRENT_DATE,INTERVAL 10 DAY) and DATE_SUB(CURRENT_DATE,INTERVAL 1 DAY)
) as 一到十天数,
sum(yourDATETIME between 
DATE_SUB(CURRENT_DATE,INTERVAL 20 DAY) and DATE_SUB(CURRENT_DATE,INTERVAL 11 DAY)
) as 十到二十天数,
sum(yourDATETIME between 
DATE_SUB(CURRENT_DATE,INTERVAL 10 DAY) and DATE_SUB(CURRENT_DATE,INTERVAL 1 DAY)
) as 二到三十天数
from yourtable