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

what is package and it uses and how can u call a package

1948

What is scan table/view and seek table/view when its occurs? : sql server database administration

984

What is a print index?

840

Explain different forms of normalization?

884

List all types of constraints in sql server?

960

How to Insert multiple rows with a single insert statement?

999

How to provide column names in insert statements in ms sql server?

1071

What are different types of constraints?

875

Is mysql better than sql server?

1000

What stored by the master? : sql server database administration

1026

Explain filestream storage of sql server 2008?

947

What is the purpose of optimization?

948

How to list all columns in a table using odbc_columns()?

934

What is indexing a document?

967

What is the purpose of linked server configuration in sql server?

985