Select last row in a table?

Question

I have a SQL table named name. It contains 1000's of names. I enter new names to the table but I forgot what are these names. So I need to see last entered row using a query like select top(10)* from name.

Vulpes · Answer

If you're using an auto-increment column (id say) then you could do this: SELECT TOP 1 * FROM table ORDER BY id DESC

Munesh Sharma · Answer

In Sql Server.. Select TOP 1 * FROM tablename ORDER BY id DESC In mySql.. Select * FROM tablename ORDER BY id DESC Limit 1