how to calculate standard deviation from a table

Поиск
Список
Период
Сортировка
От Pierre Hsieh
Тема how to calculate standard deviation from a table
Дата
Msg-id CADT0GeuJgYQzQv5iQr11r_KaGZAbqwX3Kb5FdZS858imbFLjuw@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to calculate standard deviation from a table  (David G Johnston <david.g.johnston@gmail.com>)
Re: how to calculate standard deviation from a table  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: How to create a specific table
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: implicit cast works for insert, not for select