SQRT(X) 返回非負數 X 的平方根。參數為負數返回 NULL。內部以雙精度浮點運算,結果為 DOUBLE 類型。
SELECT SQRT(16); -- 4.000000
SELECT SQRT(2); -- 1.4142135623730951
SELECT SQRT(-1); -- NULL
SELECT name, daily_typing_pages,
SQRT(daily_typing_pages) AS sqrt_pages
FROM employee_tbl;
+------+--------------------+--------------+
| name | daily_typing_pages | sqrt_pages |
+------+--------------------+--------------+
| John | 250 | 15.811388 |
| Ram | 220 | 14.832397 |
| Jack | 170 | 13.038405 |
| Jack | 100 | 10.000000 |
| Jill | 220 | 14.832397 |
| Zara | 300 | 17.320508 |
| Zara | 350 | 18.708287 |
+------+--------------------+--------------+
SELECT EXP(AVG(LOG(daily_typing_pages))) AS geo_mean
FROM employee_tbl; -- 等價於 n 次方根的乘積
SELECT name,
STDDEV_POP(daily_typing_pages) AS pop_std,
SQRT(VAR_POP(daily_typing_pages)) AS manual_std -- 驗證標準差 = 方差開根
FROM employee_tbl
GROUP BY name;
SELECT SQRT(POW(x2-x1,2) + POW(y2-y1,2)) AS distance
FROM points;
DECIMAL + 專用庫。SQRT 為 CPU 密集型,可考慮應用層預計算或 GPU 加速。SQRT(col),若頻繁按平方根篩選,建議建立函數索引(MySQL 8.0+)或物化列。SQRT() 使用極簡單,但結合 POW()、LOG()、EXP() 可構建豐富數學統計指標。記住負數返回 NULL、結果為 DOUBLE、大量計算關注 CPU 開銷即可靈活駕馭。