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

Explain about protocol layer present in SQL server?

1133

When do you think a developer should use sql server-based cursors?

994

What are the restrictions applicable while creating views? : SQL Server Architecture

992

How to send email from database?

970

Explain indexed views?

940

Write a sql query to display the current date?

1047

Explain the Ways to improve the performance of a sql azure database?

Why should we go for stored procedures? Why not direct queries?

1048

What is it unwise to create wide clustered index keys?

970

Explain about Normalization?

1026

What are the different types of sql server replication? : sql server replication

1192

What does it mean to normalize data?

907

What is the difference between ‘having’ clause and a ‘where’ clause?

1008

1 01 101 01010

2016

Explain unique key in sql server?

975