If you want to directly access the most "recent" row in a SQL database, you'll probably need to include a timestamp column on the table and then order on it. The concept of "TOP X" is just the first X rows returned by your query according to whatever ORDER BY clause you've given. There is no native concept of time inherent in SQL tables. Rather, that sort of information is stored in transaction logs for purposes of rollback and recovery.
If you're editing a table directly in something like SQL Server Management Studio, sometimes opening the whole table will have the most recently added rows at the bottom, but this is by no means guaranteed.