1
$\begingroup$

I am trying to do some work that is primarily based in SQL Server. I cannot seem to find a native function to SQL that supports the Poisson distribution. Has anyone had success with applying Poisson natively within SQL?

$\endgroup$
  • 3
    $\begingroup$ I am super curious as to the reason you wish to apply the Poisson distribution in a query. Can you elaborate. $\endgroup$ – JahKnows Mar 10 '17 at 17:29
  • 1
    $\begingroup$ Do you want the CDF, the PDF, samples from it? $\endgroup$ – Spacedman May 11 '17 at 13:29
  • $\begingroup$ Hi, if my answer clarified your understanding of SQL Server support for Poisson distribution, may I ask you to upvote my answer? :) $\endgroup$ – VividD May 18 '17 at 3:47
1
$\begingroup$

Yes, SQL Server does support it, as a part of Data Analysis Expressions (DAX).

The documentation for the function for getting Poisson distribution data is here.

| improve this answer | |
$\endgroup$
0
$\begingroup$

It seems that someone has managed to implement a Poisson sampling in SQL Server. Checkout this link: http://bilquist.com/poisson-sampling-in-sql/

| improve this answer | |
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.