mysql question

[Kroonen]

Hi,

I want an sql statement for last week, month etc

When I run this i get all, but how do I limit it for last week last month?

I have this

Select sum(verbruik), YEAR(time) AS jaar, WEEK(time,5) AS week, DAY(time) AS day from rfxpower group by jaar, week, day

[b_weijenberg]

http://www.plus2net.com/sql_tutorial/sql_having.php