how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
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 |
Post New Answer View All Answers
What is a collation?
What is “asynchronous” communication in sql server service broker?
What is a sql join?
What is partitioned view?
What is optimization and its types?
What are the reporting services components?
What is difference between aggregate and analytic function?
what is denormalization and when would you go for it? : Sql server database administration
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What xml support does the sql server extend?
What is the difference between push and pull subscription? : sql server replication
How do I open port 1433?
How dts is used to extract, transform and consolidate data?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How do I view a stored procedure in sql server query?