ID Total Amount 1 10 3 2 10 2 3 10 1 4 10 0
SELECT * FROM test WHERE Total / Amount = 5
SELECT * FROM ( SELECT * FROM test WHERE Amount > 0 ) a WHERE a.Total / a.Amount = 5
SELECT * FROM test WHERE (Total / NULLIF(Amount, 0)) = 5
SELECT * FROM test WHERE Amount > 0 AND Total / Amount = 5
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)