Re: Re: Re: Untitled

From Little Zebra, 4 Months ago, written in Plain Text, viewed 111 times. This paste is a reply to Re: Re: Untitled from Gray Duck - view diff
URL http://codebin.org/view/220a89af Embed
Download Paste or View Raw
  1. SELECT customer_id,
  2.        DATE_TRUNC('hour',CAST(invoice_date AS date)),
  3.        total-- сюда запишите нужные поля
  4. FROM invoice
  5. WHERE EXTRACT(MONTH FROM CAST(invoice_date AS timestamp)) = 9
  6. AND customer_id IN(11,13,44,36,48,52,54,56);

Reply to "Re: Re: Re: Untitled"

Here you can reply to the paste above