- SELECT
- EXTRACT (DAY FROM creation_date),
- COUNT(id) OVER (PARTITION BY creation_date),
- SUM(id) OVER (PARTITION BY creation_date)
- FROM stackoverflow.users
- wHERE creation_date::date BETWEEN '2008-11-01' AND '2008-11-30'
- GROUP BY EXTRACT (DAY FROM creation_date),id,creation_date;
Re: Re: Untitled
From Toxic Baboon, 4 Months ago, written in Plain Text, viewed 94 times.
This paste is a reply to Re: Untitled from Tacky Sheep
- view diff
URL http://codebin.org/view/99a9f299
Embed
Download Paste or View Raw
— Expand Paste to full width of browser