Write a SQL query to find the LAST inserted record in a table?

 Write a SQL query to find the LAST inserted record in a table?

                                                       

Answer:

below query…


select * from t where COLUMN_NAME = (select max(COLUMN_NAME)
from T) and rownum = 1;

Post a Comment

0 Comments