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

How does index makes search faster?

595


Does sql server use java?

514


What is the purpose of indexing?

595


What is the need for group functions in sql?

561


What are the different types of normalization?

615






How to find the second highest salary of an employee?

583


Explain the microsoft sql server delete command?

530


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

519


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


Difference between LEN() and DATALENGTH() in sql server ?

590


What is the syntax to execute the sys.dm_db_missing_index_details?

580


What are “lock” hints?

585


what is the main function of a query parameter?

111


What are the different type of replication in sql server?

534


What is row_number function?

588