Answers for "oracle select last row"

SQL
4

oracle delete last row

DELETE FROM my_table WHERE my_col_id = (SELECT MAX(my_col_id) FROM my_table);
Posted by: Guest on June-20-2021
-1

sql oracle take only last results

select * from table_name ORDER BY primary_id DESC FETCH FIRST 1 ROWS ONLY;
Posted by: Guest on July-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language