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 |
What is the use of partition by in sql server?
How to loop through result set objects using mssql_fetch_array()?
Difeerence between ssis 2005 and ssis2008?
What kind of problems occurs if we do not implement proper locking strategy?
What are constraints? Explain different types of constraints?
26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,
What are pessimistic lock and optimistic lock?
Write a SQL Query to find first Week Day of month?
What are “lost updates”?
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
What is difference between rownum and row_number?
Can we call future method from queueable?
What are the steps to take to improve performance of a poor performing query? : sql server database administration