/*
Author Aamir Hasan
phone no : 092 333 5494532
Site: aspxtutorial.com
*/

CREATE TABLE #STUDENT(ID BIGINT IDENTITY,FULLNAME NVARCHAR(MAX),AGE INT,GENDER CHAR(1),STATUS BIT DEFAULT(0))

INSERT INTO #STUDENT VALUES('Aamir Hasan',25,'M',0)
INSERT INTO #STUDENT VALUES('Aamir Hasan',24,'M',0)
INSERT INTO #STUDENT VALUES('Saida Hasan',23,'F',0)
INSERT INTO #STUDENT VALUES('Aamir Hasan',22,'M',0)
INSERT INTO #STUDENT VALUES('Saba Hasan',21,'F',0)

SELECT * FROM #student

SELECT TOP 1 * FROM #student ORDER BY id DESC
DROP TABLE #student