CREATE TABLE Emp(

EmpName VARCHAR(9),

Age INT,

MaritalStatus char(1))

INSERT INTO Emp VALUES ('Abhinav',40,'S')

INSERT INTO Emp VALUES ('Dhvani',20,'M')

INSERT INTO Emp VALUES ('Nehal',20,'M')

INSERT INTO Emp VALUES ('Sunil',95,'M')

INSERT INTO Emp VALUES ('Suvrendu',40,'M')

INSERT INTO Emp VALUES ('Bill',11,'S')

INSERT INTO Emp VALUES ('Ram',100,'S')

INSERT INTO Emp VALUES ('Nirmal',50,'S')

INSERT INTO Emp VALUES ('R',30,'S')

SELECT Dense_RANK() OVER (ORDER BY Age) AS [Rank by Age],

EmpName,

Age

FROM Emp

Like this model u try this example.