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 |
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
How to add a new dsn with the odbc driver for sql server?
Explain the functionalities that views support?
How to truncate the log in sql server 2012? : sql server database administration
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
How check triggers in sql server?
How to list all user names in a database?
What do you mean by data integrity?
what is IDE,DMV in sql server?
find the 3rd max salary
How will u get 5 years back record?