CREATE TABLE table_204_886 (id NUMBER, "rank" NUMBER, "swimmer" CLOB, "country" CLOB, "time" CLOB, "note" CLOB)

who was the last competitor to actually finish the preliminaries ?
SELECT "swimmer" FROM table_204_886 ORDER BY "rank" DESC LIMIT 1
SELECT "swimmer" FROM "table_204_886" ORDER BY "rank" DESC FETCH FIRST 1 ROWS ONLY