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 are the features of Embedded SQL
what is database replicaion? : Sql server database administration
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the process of normalising?
How do I debug a stored procedure in sql server?
Explain the rules for designing files and file groups in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to populate a table in sql server?
Explain DBCC?
What is the bookmark lookup and rid lookup?
What are the different kinds of ssrs reports?
What are the differences between triggers and stored procedures?
Define self join?
How many non clustered indexes there can be on table ?
please differentiate between delete and truncate?