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 7 disadvantages to a manual system?

987

Can you explain powershell included in sql server 2008?

944

How to generate create view script on an existing view?

992

what is a self join? Explain it with an example? : Sql server database administration

956

how you can configure a running aggregate in SSRS?

190

What is shared lock?

907

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1403

How to throw custom exception in Stored Procedure?

1047

How to transfer a table from one schema to another?

1007

What is difference between equi join and inner join?

960

What are ddl (data definition language) statements for tables in ms sql server?

1105

What is Replication?

1054

What is 1nf 2nf?

1014

How can I check if a view exists in a sql server database?

1042

How many ways to create table-valued functions?

999