select * from student where rank = a;

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

Question Posted / raju

Answer Posted / raju

Is This Answer Correct ?

1 Yes

15 No

Please Help Members By Posting Answers For Below Questions

How do I shrink an ldf file?

1034

Does a server store data?

951

How to loop through result set objects using mssql_fetch_array()?

1127

What is RAID? What are the different types of RAID configurations?

1178

Do you know what is difference between stored procedure and user defined function?

1146

How to populate a table in sql server?

989

What is snapshot replication?

1095

Is foreign key unique?

1043

How do I determine how many instances of sql server are installed on a computer?

1052

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1131

What is order of B+tree?

1152

How can sql injection be stopped? : sql server security

1097

what are the types of indexes? : Sql server database administration

1174

How use inner join in sql server?

1184

What is the log shipping?

1056