Retrieving latest Record in to the table

Question

I have one table temp(sid integer, sname varchar, adress varchar)

This table contains 10 records I need to retrieve latest insert records

Answer 1

A simple select statement should do it

SELECT * from temp 
ORDER BY sid DESC
LIMIT 1