select rank from student; (because we dont know if the rank field is ins

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

Question Posted / abi

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

Please Help Members By Posting Answers For Below Questions

What Are the Main Features of SQL Azure?

115

What is @@error in sql?

1034

Write a program to fetch first 10 records from a file?

979

What can be used instead of trigger?

1113

How to update multiple rows with one update statement in ms sql server?

1161

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

1182

What stored by the model?

1004

Explain a checkpoint?

990

What are the components of dbms?

918

What is the maximum size per database for sql server express?

991

What are the disadvantages of using the stored procedures?

1038

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1178

What is the difference between Stored Procedures and triggers?

1052

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1072

How to find the login name linked to a given user name?

963