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 three command line utilities and what are their primary functions?

101


What is the difference between resultset and resultsetmetadata?

521


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

721


What is the command used to recompile the stored procedure at run time?

625


What are the different types of backups avaialabe in sql server 2005?

630






What is the difference between upgrade and migration in sql server?

598


What is database replication? What are the different types of replication you can set up in sql server?

502


How do you manipulate data?

499


What are joins in sql and what are the different types of joins?

554


What is inline variable assignment?

607


How to find tables without indexes?

634


What is optimization and its types?

539


How to receive returning result from a query?

586


What is a document index?

590


What is a primary key?

544