how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / naveen
place identity on a column at the time of creating table
Ex:
create table test(studentrank identity(1,1))
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / abi
select rank from student;
(because we dont know if the rank field is inserted r not)
Is This Answer Correct ? | 0 Yes | 4 No |
Is it ok to shrink transaction log?
How to make a remote connection in a database?
Write a code to select distinct records without using the DISTINCT keyword.
Do you know how to make remote connection in database?
How to trouble shoot if unable to connect SQL Server
What Are Three Rules to UseĀ UNION IN SQL SERVER
What are the transaction properties?
What is the sql server agent?
Creating Tables Using SELECT
You want to implement the one-to-many relationship while designing tables. How would you do it?
Explain about Views?
Will the writetext statement activate a trigger?