PostgreSQL 中查询给出除零错误

PostgreSQL中查询给出除零错误的问题及解决方法

sql
SELECT column1, column2, 
    CASE 
        WHEN column2 <> 0 THEN column1 / column2 
        ELSE 0 
    END AS division_result
FROM table;

sql
CREATE TABLE sales (
    id SERIAL PRIMARY KEY,
    sales_amount DECIMAL,
    cost DECIMAL
);
INSERT INTO sales (sales_amount, cost) VALUES
    (1000, 500),
    (2000, 0),
    (3000, 1000);
SELECT id, sales_amount, cost,
    CASE
        WHEN cost <> 0 THEN sales_amount / cost
        ELSE 0
    END AS profit_margin
FROM sales;