I want to delete a row in the table which should be ordered by a coloumn and then delete the first row in that table. How does I can make this work? My SQL statement is
"DELETE FROM EVENT_QUE (SELECT * FROM EVENT_QUE ORDER BY TRANSITION_TIMESTAMP) WHERE ROWNUM = 1";
First I need to order the table by coloumn TRANSITION_TIMESTAMP and then I need to delete the first row.
I am getting SQL command has not properly ended , Can any body make out what I am wrong here.