CREATE TABLE table_204_29 (id NUMBER, "rank" NUMBER, "lane" NUMBER, "name" CLOB, "nationality" CLOB, "time" CLOB, "notes" CLOB)

who performed better , goddard or francis ?
SELECT "name" FROM table_204_29 WHERE "name" IN ('james goddard', 'charles francis') ORDER BY id LIMIT 1
SELECT "name" FROM "table_204_29" WHERE "name" IN ('james goddard', 'charles francis') ORDER BY "id" FETCH FIRST 1 ROWS ONLY