use dense_rank over(partition by stu_exam_date order by stu_id) as stu

how to get rank of diffrent student in same table based on
newly inserted row in sql server2008

Question Posted / diveyandu

Answer Posted / diveyandu

use dense_rank over(partition by stu_exam_date order by
stu_id) as stu_rank show a particular date student exam or
diff activity rank

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do we need different type of parameter?

1045

What do mean by xml datatype?

1085

Which command is used for user defined error messages?

1057

What is ms sql server index?

1088

Can I delete event logs?

918

What are the main differences between #temp tables and @table variables and which one is preferred?

1074

Mention the different authentication modes in sql server.

1038

What stored by the msdb?

989

What is attribute? : sql server analysis services, ssas

1012

What are the instances when triggers are appropriate?

977

What does man by sql wildcard characters in sql server?

1050

Define views.

1001

What is the latest version of microsoft sql server?

1037

Explain filestream storage of sql server 2008?

1006

What is an active database?

1003