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

when you create a database how is it stored? : Sql server database administration

940

what is the different types of backups available in sql server? : Sql server database administration

880

What is the default order of an order by clause?

944

Explain insert into select statement?

899

How to create a user to access a database in ms sql server using "create user" statements?

912

what is a join? : Sql server database administration

1125

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1068

Tell me what is log shipping?

935

What are trace flags and mention a few common trace flags used with sql server?

1036

what is difference between NULL and ISNULL in SQL Server 2008?

965

How to get a list all databases on the sql server?

1025

What is triggers in ms sql server?

1049

How to get the query of a table in sql server?

849

What does dml stand for?

904

How can you check the version of sql server?

1047