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

who comes before marco loughran ?
SELECT "name" FROM table_204_29 WHERE "rank" = (SELECT "rank" FROM table_204_29 WHERE "name" = 'marco loughran') - 1
SELECT "name" FROM "table_204_29" WHERE "rank" = (SELECT "rank" FROM "table_204_29" WHERE "name" = 'marco loughran') - 1