CREATE TABLE table_204_173 (id NUMBER, "rank" NUMBER, "group" CLOB, "name" CLOB, "nationality" CLOB, "2.05" CLOB, "2.15" CLOB, "2.19" CLOB, "2.23" CLOB, "2.26" CLOB, "result" CLOB, "notes" CLOB)

who is above martyn bernard
SELECT "name" FROM table_204_173 WHERE id = (SELECT id FROM table_204_173 WHERE "name" = 'martyn bernard') - 1
SELECT "name" FROM "table_204_173" WHERE "id" = (SELECT "id" FROM "table_204_173" WHERE "name" = 'martyn bernard') - 1