CREATE TABLE table_25794 ("Rank" FLOAT, "City/Town" CLOB, "County" CLOB, "Region/Province" CLOB, "Population" FLOAT, "Country" CLOB)

When 142900 is the population what is the highest rank?
SELECT MAX("Rank") FROM table_25794 WHERE "Population" = '142900'
SELECT MAX("Rank") FROM "table_25794" WHERE "Population" = '142900'