PostgreSQL　最小公倍数を取得するサンプル

2024年3月20日

環境
Windows 10 Home 64bit
PostgreSQL 9.6.5

構文
lcm(数値,数値);
※指定した2つの数値の最小公倍数を取得します
最小公倍数を取得するには、「lcm」を使用します。

使用例

SELECT

lcm(5, 2) AS "lcm(5, 2)",

lcm(10, 8) AS "lcm(10, 8)",

lcm(6.6, 1.1) AS "lcm(6.6, 1.1)",

lcm(-12, 6) AS "lcm(-12, 6)";

SELECT lcm(5, 2) AS "lcm(5, 2)", lcm(10, 8) AS "lcm(10, 8)", lcm(6.6, 1.1) AS "lcm(6.6, 1.1)", lcm(-12, 6) AS "lcm(-12, 6)";

SELECT
    lcm(5, 2) AS "lcm(5, 2)",
    lcm(10, 8) AS "lcm(10, 8)",
    lcm(6.6, 1.1) AS "lcm(6.6, 1.1)",
        lcm(-12, 6) AS "lcm(-12, 6)";

Posted by arkgame