### Calculating Pi Using Only Pure SQL

Suppose table Numbers has numbers from 1 to 1000.

The problem: using pure SQL find the closest approximation to Pi number as a ratio of two integers. The integers should not exceed 999.

The solution is:

SELECT TOP 100 m, n, c FROM(

SELECT n1.Number m, n2.Number n, ABS(SIN(1.0*n1.Number/n2.Number)) c

FROM Numbers n1, Numbers n2

WHERE n1.Number BETWEEN 100 AND 999

AND n2.Number BETWEEN 100 AND 999) t

ORDER BY c

The answer is 355/113.

## 0 Comments:

Post a Comment

<< Home