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 use of expression builder.

1031

What is the significance of master, tempdb and model databases?

1084

What is ms sql server index?

1111

What is not null constraint?

1134

How global temporary tables are represented and its scope?

985

Can primary key be null?

939

Explain different types of index?

1066

What do you understand by hotfixes and patches in sql server?

998

To which devices can a backup be created and where should these devices be located? : sql server management studio

1054

What is Sqlpaging in SqlServer 2005 ?

1072

What are the types of processing and explain each? : sql server analysis services, ssas

1158

How do you run a trace?

908

What is a linked server in sql server?

1082

Explain how to send email from sql database?

1056

What is a trace frag? Where do we use it?

1108