Re: Re: Re: Re: Untitled

From Torrid Panda, 2 Months ago, written in Plain Text, viewed 104 times. This paste is a reply to Re: Re: Re: Untitled from Sharp Terrapin - view diff

URL http://codebin.org/view/e5d176cc Embed

Download Paste or View Raw

SELECT *
FROM
(SELECT count(total) as year_2011,
EXTRACT(month from CAST(invoice_date AS timestamp)) as month
FROM invoice
where EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2011
GROUP BY month) as year2011
FULL JOIN
(SELECT count(total) as year_2012
EXTRACT(month from CAST(invoice_date AS timestamp)) as month
FROM invoice
where EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2012
GROUP BY month) as year2012 ON year2011.month=year2012.month

Reply to "Re: Re: Re: Re: Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?