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

whats the maximum size of view state??

1727


How do you debug a procedure in sql server?

501


What is the guest user account in sql server? What login is it mapped to it? : sql server security

589


How you can get the list of largest tables in a database?

535


What are the different Authentication modes in SQL Server and how can you change authentication mode?

648






Explain what is lock escalation?

583


What is difference statement and preparedstatement?

552


What are the commands used in DCL?

569


What is page in sql server?

520


What are the transaction properties?

564


What is trigger and different types of Triggers?

580


What encryption security is available in sql azure?

81


What is a transactions?

608


Explain index in sql server?

601


How to add the custom code in Report?

99