Problem With Rank()

Question

Hi... In my database i have tables like tblsubject(sid,sname),tblexam(eid,ename),tblexaminf0(exid,eid,maxmarks,minmarks),tblprogress(pid,exid,seuredmarks)tblstudadmisform(studentid,class,name,fname) i want to display ranks of the sutdents i wirte query like ALTER PROCEDURE [dbo].[Sp_getProgress] @studentid varchar(50), @examTypeId int , @ScId int, @BrId int as select regd_no, SubjectName,CONVERT(int,MaxMarks) as MaxMarks,CONVERT(int,SecuredMarks) as SecuredMarks,ei.examId,ExamType,minmarks,--sa.Class_admission,ei.examinfoId, case when CONVERT(int,SecuredMarks)