Hello,

--You can get LAST ROW without using INDEX or IDENTITY COLUMN or TIMESTAMP COLUMN
--- FIND OUT LAST INSERTED ROW WITHOUT USING INDEX / IDENTITY COLUMN / TIME STAMP COLUMN 

--Create a table
CREATE TABLE TestLastQuery (
    Name    VARCHAR (50),
    Address VARCHAR (70)
);

--Insert the values
INSERT  INTO TestLastQuery (Name, Address)
VALUES                    ('Pawan', 'Pune ');

INSERT  INTO TestLastQuery (Name, Address)
VALUES                    ('Gauri', 'A Nagar ');

INSERT  INTO TestLastQuery (Name, Address)
VALUES                    ('Saurabh', 'A Nagar ');

INSERT  INTO TestLastQuery (Name, Address)
VALUES                    ('Himanshu', 'Padmavati ');

INSERT  INTO TestLastQuery (Name, Address)
VALUES                    ('Rahul W', ' Jordan');

-- Use the below query to find out the last inserted row
SELECT   TOP 1 Name,
               Address,
               row_number() OVER ( ORDER BY (SELECT 2)) AS ROWNUMBER
FROM     TestLastQuery
ORDER BY ROWNUMBER DESC;

Submitted under: Microsoft SQL Server · TSQL ·  ·  ·