CREATE TABLE table_204_152 (id NUMBER, "device" CLOB, "type" CLOB, "iops" CLOB, "interface" CLOB, "notes" CLOB)

which interface appears first , sata 6 gbit/s or pcie ?
SELECT "interface" FROM table_204_152 WHERE "interface" IN ('sata 6 gbit/s', 'pcie') ORDER BY id LIMIT 1
SELECT "interface" FROM "table_204_152" WHERE "interface" IN ('sata 6 gbit/s', 'pcie') ORDER BY "id" FETCH FIRST 1 ROWS ONLY