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

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

945

What are the differences between DDL, DML and DCL in SQL?

1191

What are the types of subquery?

997

Which is faster statement or preparedstatement?

909

What are distributed partitioned views?

1026

What is the command used to check locks in microsoft sql server?

995

Tell me what is log shipping?

952

What is the difference between mysql and mysqli?

1123

How to rebuild indexes with alter index ... Rebuild?

1062

What is a derived table?

889

What is indexed view?

947

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

865

How to create an inline table-valued function?

931

Will sql server 2005 allow you to reduce the size of a column?

942

What is a result set object returned by odbc_exec()?

986