Last record by id

Hi Firuz,

Refer the below query.

SQL

DECLARE @PersonTable AS TABLE(Id INT,PersonId INT,Weight INT,Hight INT,Hair VARCHAR(10),Character VARCHAR(10),Mood VARCHAR(10))
INSERT INTO @PersonTable VALUES(1,1,60,160,'Black','Fanny','Good')
INSERT INTO @PersonTable VALUES(2,2,90,195,'White','Serious','Fine')
INSERT INTO @PersonTable VALUES(3,1,60,160,'Black','Fanny','Bad')
INSERT INTO @PersonTable VALUES(4,2,60,160,'White','Serious','Bad')

SELECT TOP 1 Weight,Hight,Hair,Character,Mood 
FROM @PersonTable
WHERE PersonId = 1
ORDER BY Id DESC

Output

Weight   Hight   Hair   Character   Mood

     60     160    Black     Fanny      Bad