Search code examples
sqlsql-serverdistribution

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

  • 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