CREATE TABLE table_204_870 (id NUMBER, "product" CLOB, "main functionality" CLOB, "input format" CLOB, "output format" CLOB, "platform" CLOB, "license and cost" CLOB, "notes" CLOB)

which product come before egonet
SELECT "product" FROM table_204_870 WHERE id = (SELECT id FROM table_204_870 WHERE "product" = 'egonet') - 1
SELECT "product" FROM "table_204_870" WHERE "id" = (SELECT "id" FROM "table_204_870" WHERE "product" = 'egonet') - 1