CREATE TABLE table_203_754 (id NUMBER, "no." NUMBER, "player" CLOB, "position" CLOB, "career" CLOB, "date no. retired" CLOB)

of these players , who had the longest career ?
SELECT "player" FROM table_203_754 ORDER BY "career" - "career" DESC LIMIT 1
SELECT "player" FROM "table_203_754" ORDER BY "career" - "career" DESC FETCH FIRST 1 ROWS ONLY