'How to change normal distribution from MySQL to SQL Server
I have a code not total like normal distribution. How can I change it from Mysql to SQL Server?
select latency
where pow(e(), - pow((ln(latency) - 8.223) ,2)/2/0.3975) /sqrt(2*pi()) / 0.53 < 0.01
order by latency desc
Solution 1:[1]
I try the code, it works.
SELECT latency
FROM abc
WHERE exp( power((log(von) - 8.223) ,2)/2/0.3975) /sqrt(2*pi()) / 0.53 < 0.01
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Jeremy Caney |