- SELECT customer_id,
- DATE_TRUNC('hour',CAST(invoice_date AS date)),
- total-- сюда запишите нужные поля
- FROM invoice
- WHERE EXTRACT(MONTH FROM CAST(invoice_date AS timestamp)) = 9
- AND customer_id IN(11,13,44,36,48,52,54,56);
Re: Re: Untitled
From Gray Duck, 9 Months ago, written in Plain Text, viewed 353 times.
This paste is a reply to Re: Untitled from Beige Dove
- view diff
URL http://codebin.org/view/08546f1d
Embed
Download Paste or View Raw
— Expand Paste to full width of browser