Here is my SQL Server query
SELECT
CASE(
SELECT POPULATION
FROM MEXICO
) WHEN 0 THEN 1 ELSE
SELECT POPULATION
FROM MEXICO
END
I need to make a query return 1 if it's value is equal to 0, is there a way to do it without repeating the SELECT?
Yes there is:
Fiddle