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
How does index makes search faster?
Does sql server use java?
What is the purpose of indexing?
What is the need for group functions in sql?
What are the different types of normalization?
How to find the second highest salary of an employee?
Explain the microsoft sql server delete command?
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?
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?
Difference between LEN() and DATALENGTH() in sql server ?
What is the syntax to execute the sys.dm_db_missing_index_details?
What are “lock” hints?
what is the main function of a query parameter?
What are the different type of replication in sql server?
What is row_number function?