how to get rank of diffrent student in same table based on
newly inserted row in sql server2008

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between stored procedure and view in sql server?

840


How to download and install microsoft .net framework version 2.0?

748


How do I find my localdb version?

713


How to convert a unicode strings to non-unicode strings?

743


What is the bookmark lookup and rid lookup?

751






Can we write ddl in trigger?

651


What is nolock?

747


What is sql azure database?

198


How to find the service pack installed? : sql server database administration

774


What structure can you implement for the database to speed up table reads?

947


How to encrypt Strored Procedure in SQL SERVER?

768


What are entities and relationships?

739


What are the restraints imposed on the table design by a merge replication?

791


How to join two tables in a single query in ms sql server?

719


What are the different normalization forms?

807