[GENERAL] how to calculate standard deviation from a table

2015-01-22 Thread Pierre Hsieh
Hi This table just has a column which type is integer. There are one million data in this table. I wanna calculate standard deviation on each 50 data by order. It means SD1 is from data 1 to data 50, SD2 is from data 51 to 100 Is there anyone who can give me some suggestions? Thanks Pierre

[GENERAL] How to create a specific table

2015-01-22 Thread Pierre Hsieh
Hi, Is there anyone who can help me to create a specific table as following? Thanks Pierre rule: 1. just one column which type is integer in table 2. this columns only has 1 and 2 for 50 times as following 1 2 1 2 1 2 1 2 .

Re: [GENERAL] Fwd: Ask for a question

2015-01-21 Thread Pierre Hsieh
! Paul On Wed, Jan 21, 2015 at 10:09 AM, Raymond O'Donnell r...@iol.ie wrote: On 21/01/2015 18:02, Pierre Hsieh wrote: Hi Raymond, Thanks for your reply. Please see detail as following. Thanks again. Can you describe *in words* what sort of calculation you want to do? Ray

Re: [GENERAL] Fwd: Ask for a question

2015-01-21 Thread Pierre Hsieh
Hi Raymond, Thanks for your reply. Please see detail as following. Thanks again. Pierre [image: Inline image 1] On Thu, Jan 22, 2015 at 1:48 AM, Raymond O'Donnell r...@iol.ie wrote: On 21/01/2015 17:32, Pierre Hsieh wrote: Hi guys, Thanks for your replies. I certainly can use VBA

Re: [GENERAL] Fwd: Ask for a question

2015-01-21 Thread Pierre Hsieh
Hi guys, Thanks for your replies. I certainly can use VBA and ADODB object in Excel to do it. Due to performance, I wanna try to do it by SQL command in PG. However, I am not expert in PG, so I need few help from your guys. Let me to describe my question clearly as following. The final results

[GENERAL] Fwd: Ask for a question

2015-01-21 Thread Pierre Hsieh
Hi, Would you please tell me whether PostgreSQL can execute the following tasks? If not, please also tell me which one can help me for that. Thanks -- *謝宗翰* *|* *台北富邦銀行* *風險管理部* *| 10686**台北市大安區仁愛路四段**169**號**12**樓**| (02) 27716699 **分機* *62853* *Pierre