CREATE TABLE table_204_342 (id NUMBER, "#" NUMBER, "player" CLOB, "span" CLOB, "caps" NUMBER, "total caps" NUMBER, "win %" CLOB)

which player has the highest win percentage ?
SELECT "player" FROM table_204_342 ORDER BY "win %" DESC LIMIT 1
SELECT "player" FROM "table_204_342" ORDER BY "win %" DESC FETCH FIRST 1 ROWS ONLY