subject:"Re\: Nested WHERE"

Re: Nested WHERE

2013-11-21 Thread Jopoy Solano

Awesome! Thank you very much Claudio! :) On Thu, Nov 21, 2013 at 10:40 AM, Claudio Nanni wrote: > Hi Jopoy, > > Try this: > > "SELECT username,sum(acctoutputoctets) AS total_usage FROM radacct WHERE > EXTRACT(YEAR_MONTH FROM acctstarttime) >= EXTRACT(YEAR_MONTH FROM > CURRENT_DATE)and EXTRACT(Y

Re: Nested WHERE

2013-11-21 Thread Claudio Nanni

Hi Jopoy, Try this: "SELECT username,sum(acctoutputoctets) AS total_usage FROM radacct WHERE EXTRACT(YEAR_MONTH FROM acctstarttime) >= EXTRACT(YEAR_MONTH FROM CURRENT_DATE)and EXTRACT(YEAR_MONTH FROM acctstarttime) < EXTRACT(YEAR_MONTH FROM CURRENT_DATE + INTERVAL 1 MONTH) GROUP BY username HAVIN